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};
That should solve your problem, I think.
--tom
>>
>> At this point I'm unclear where the permissions problem exists.
>
> Within PostgreSQL. The PostgreSQL user does not have permissions on that
> table…
>
> This is not a Unix permissions issue.
>
>>
>> Thanks in advance for further clues.
>>
>> dn
>>
>>
>>
>>>
>>> I am not using 5.2.2, so I did the version table as an example of what it
>>> should look like.
>>>
>>>>
>>>> bacula-# \l
>>>> List of databases
>>>> Name | Owner | Encoding
>>>> -----------+--------+-----------
>>>> bacula | bacula | SQL_ASCII
>>>> postgres | pgsql | UTF8
>>>> template0 | pgsql | UTF8
>>>> template1 | pgsql | UTF8
>>>> (4 rows)
>>>>
>>>> User bacula's shell is defined as /sbin/nologin, so I think it's user
>>>> pgsql that's doing the work (at least it was prior to the upgrade). User
>>>> bacula cannot launch psql nor can I su to that user because of the
>>>> nologin setting.
>>>>
>>>> What permissions do I need to change to get this dump working?
>>>>
>>>> Thanks again!
>>>>
>>>> dn
>>>>
>>>>>
>>>>>>
>>>>>> I have restarted all bacula and postgresql daemons since the upgrade. I
>>>>>> have not changed any permissions in the /home/bacula directory.
>>>>>>
>>>>>> Thanks in advance for troubleshooting clues.
>>>>>>
>>>>>> dn
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> Write once. Port to many.
>>>>>> Get the SDK and tools to simplify cross-platform app development. Create
>>>>>> new or port existing apps to sell to consumers worldwide. Explore the
>>>>>> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
>>>>>> http://p.sf.net/sfu/intel-appdev
>>>>>> _______________________________________________
>>>>>> Bacula-users mailing list
>>>>>> Bacula-users@lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>>>>
>>>>
>>>
>>
>
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
