All, I want to thank Michel Figgins, Dan Langille, Dimitri Maziuk, and Serio Gelato for replying to my request for help.
I'm working on it, but a variety of circumstances mean it will probably be a couple of days before I have results. Thanks. Ken -----Original Message----- From: kjohn...@eclypse.org [mailto:kjohn...@eclypse.org] Sent: Monday, May 03, 2021 5:17 PM To: 'bacula-users' Subject: [Bacula-users] postgres createdb for bacula fails As time permits, I am working on an sqlite to postgres conversion of a bacula database, in preparation for upgrading from Debian 9 to Debian 10. For a variety of reasons I believe I am pretty close. But... There are three systems involved: the live server (Debian 9), the system where the database conversion occurs, and a test system (Debian 9) that I am using to confirm to the extent possible that the database conversion has been successful. The next step in my testing is to create an empty bacula database on the test system and restore it from the pg_dump file created on the conversion system. I have learned that the bacula postgres database needs to have encoding SQL_ASCII. Here's the difficulty. As user bacula on the test system: $ export LC_ALL=C $ createdb -E SQL_ASCII -T template0 bacula createdb: database creation failed: ERROR: encoding "SQL_ASCII" does not match locale "en_US.UTF-8" DETAIL: The chosen LC_CTYPE setting requires encoding "UTF8". Probably, fixing this is something that everyone else knows. Unfortunately, my Google searches find too much or almost nothing. A specific search of the mailing list archive found a discussion of why SQL_ASCII was so important (circa 2009), but not an answer to this problem. At least, not one that I recognized. (same failure without the export, by the way). The documentation for Bacula 7.4 (https://www.bacula.org/7.4.x-manuals/en/main/Installing_Configuring_Post.ht ml) also states that SQL_ASCII is essential, but I did not recognize a solution to this problem there. bacula 7.4.4 postgres 9.6 A solution to this problem, or a fairly tight direction to the relevant documentation would be very much appreciated. Thanks in advance for your attention. Ken _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
