-----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/[email protected]/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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
