Re: [Bacula-users] moving from UTF-8 to SQL_ASCII
2009-06-13 17:46:59
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
David Newman wrote:
> bacula-server-3.0.0, postgresql-server-8.2.13
>
> Looking for guidance on moving a database from UTF-8 to SQL_ASCII.
>
> I've been getting a bunch of warnings like this since moving to bacula 3.x:
>
> bacula-dir JobId 0: Warning: Encoding error for database "bacula".
> Wanted SQL_ASCII, got UTF8
>
> I am apparently using UTF-8:
>
> nye# su - pgsql -c 'psql -l | grep bacula'
> bacula | bacula | UTF8
>
> Dan Langille's message here suggested a fix:
>
> http://www.mail-archive.com/bacula-devel AT lists.sourceforge DOT
> net/msg02632.html
>
> But these instructions produced a database-not-found error:
>
> nye# sudo su - pgsql -c 'pg_dump /usr/home/bacula/baculaold >
> /tmp/bacula.sql'
> pg_dump: [archiver (db)] connection to database
> "/usr/home/bacula/baculaold" failed: FATAL: database
> "/usr/home/bacula/baculaold" does not exist
>
> This is odd, since that file does exist and is world-readable:
>
> nye# ls -l /usr/home/bacula/baculaold
> total 290
> -rw-r--r-- 1 bacula bacula 140976 Oct 25 2007 baculaold
That is most likely not a database. It is highly unlikely for
PostgreSQL to be storing data there.
I suspect the problem starts with the pg_dump. I think what you want to
do is:
pg_dump bacula > bacula.sql
This dump the bacula database and store it in a file, bacula.sql.
PostgreSQL database names do not usually contain paths. You can view
your PostgreSQL databases with this command: psql -l
- --
Dan Langille
BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon - The PostgreSQL Conference: http://www.pgcon.org/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.11 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAko0HTgACgkQCgsXFM/7nTx2AwCdFlFpmyYHTvLSaBQF6FNTEW3u
tUwAoN86Ofefu3RgMKwX6VRMdJhkecpu
=v4Ci
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|