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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users