Re: [Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-23 Thread David Newman
On 12/23/11 5:27 PM, Thomas Lohman wrote: > The update postgres script for 5.2.x is missing these two lines which > you can run manually from within psql (connect to the bacula db as your > Postgres admin db user): > > grant all on RestoreObject to ${bacula_db_user}; > grant select, update on re

Re: [Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-23 Thread Thomas Lohman
The update postgres script for 5.2.x is missing these two lines which you can run manually from within psql (connect to the bacula db as your Postgres admin db user): grant all on RestoreObject to ${bacula_db_user}; grant select, update on restoreobject_restoreobjectid_seq to ${bacula_db_user};

Re: [Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-23 Thread Dan Langille
On Dec 23, 2011, at 6:26 PM, David Newman wrote: > On 12/23/11 2:38 PM, Dan Langille wrote: >> >> On Dec 23, 2011, at 5:35 PM, David Newman wrote: >> >>> On 12/23/11 2:21 PM, Dan Langille wrote: On Dec 20, 2011, at 1:19 PM, David Newman wrote: > bacula 5.2.2, FreeBSD 8.2-RELEASE >

Re: [Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-23 Thread David Newman
On 12/23/11 2:38 PM, Dan Langille wrote: > > On Dec 23, 2011, at 5:35 PM, David Newman wrote: > >> On 12/23/11 2:21 PM, Dan Langille wrote: >>> On Dec 20, 2011, at 1:19 PM, David Newman wrote: >>> bacula 5.2.2, FreeBSD 8.2-RELEASE After upgrading bacula-server from 5.0.3 to 5.2.2 u

Re: [Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-23 Thread Dan Langille
On Dec 23, 2011, at 5:35 PM, David Newman wrote: > On 12/23/11 2:21 PM, Dan Langille wrote: >> On Dec 20, 2011, at 1:19 PM, David Newman wrote: >> >>> bacula 5.2.2, FreeBSD 8.2-RELEASE >>> >>> After upgrading bacula-server from 5.0.3 to 5.2.2 using FreeBSD ports >>> and updating the (PostgreSQL

Re: [Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-23 Thread David Newman
On 12/23/11 2:21 PM, Dan Langille wrote: > On Dec 20, 2011, at 1:19 PM, David Newman wrote: > >> bacula 5.2.2, FreeBSD 8.2-RELEASE >> >> After upgrading bacula-server from 5.0.3 to 5.2.2 using FreeBSD ports >> and updating the (PostgreSQL) bacula database, all jobs run fine except >> for the final

Re: [Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-23 Thread Dan Langille
On Dec 20, 2011, at 1:19 PM, David Newman wrote: > bacula 5.2.2, FreeBSD 8.2-RELEASE > > After upgrading bacula-server from 5.0.3 to 5.2.2 using FreeBSD ports > and updating the (PostgreSQL) bacula database, all jobs run fine except > for the final one on the bacula server, the one that dumps the

[Bacula-users] catalog pg_dump fails after 5.2.2 upgrade

2011-12-20 Thread David Newman
bacula 5.2.2, FreeBSD 8.2-RELEASE After upgrading bacula-server from 5.0.3 to 5.2.2 using FreeBSD ports and updating the (PostgreSQL) bacula database, all jobs run fine except for the final one on the bacula server, the one that dumps the catalog before making a backup. The error looks like this: