>>>>> On Wed, 15 Aug 2007 18:27:04 -0400, Tod Hagan said: > > All, > > I encountered errors from the update_postgresql_tables script in 2.0.3 > when converting an old 1.38.8 postgresql database: > > > sudo /etc/bacula/update_bacula_tables -h node002 > Password: > Altering PostgreSQL tables > > This script will update a Bacula PostgreSQL database from version 9 > to 10 > which is needed to convert from Bacula version 1.38.x to 2.0.0 or > higher > Depending on the size of your database, > this script may take several minutes to run. > > psql:<stdin>:2: ERROR: must be owner of relation media > . > . > . > postgres=# \du > List of roles > Role name | Superuser | Create role | Create DB | Connections | > Member of > > -----------+-----------+-------------+-----------+-------------+----------- > bacula | no | no | yes | no limit | > postgres | yes | yes | yes | no limit | > root | no | no | yes | no limit | > (3 rows) > > postgres=# \q > > sudo psql -l > List of databases > Name | Owner | Encoding > -----------+----------+----------- > bacula | root | SQL_ASCII > postgres | postgres | UTF8 > template0 | postgres | UTF8 > template1 | postgres | UTF8 > (4 rows) > > Should update_bacula_tables be run while su'ed to the postgres user?
Probably. What does \dt show as the owner of the media tables in the bacula db? You'll also need to run grant_postgresql_privileges again afterwards (for the new tables). __Martin ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
