I was never able to get the scripts triggered from dpkg-reconfigure to work, even after loosening up Postgres authentication (I enabled ident allowing unix users to log in as various postgres users).
I recreated the database with a mix of psql processing and running some of the scripts that came with the package (in /usr/share/bacula-director): make_postgresql_tables and grant_postgresql_tables. My first crack created a database with UTF8 encoding; this didn't work. ISO-ANSI did (and is in some of the other scripts). To get those commands to work I had to specify the additional argument -U bacula. Without that, the failures looked like the ones I got under dpkg-reconfigure. To recap: The default Debian postgres 8.1 only allows ident authentication for linux user postgres as postgres user postgres. Loosening ident based authentication still starts with the linux user, so jobs running as root are not going to be the right postgres user unless they give that user as an explicit argument. Ross -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
