On Thu, 2007-06-07 at 12:57 +0200, Johannes Konert wrote:
> > use sudo in your backup scenario, or run you backup as postgres
> >
> Thanks for your quick reply.
> Unfortunaltelly runing backup via sudo is not an option due to sercurity
> issues and using postgres-user is not feasable because other data as
> well is backuped where postgres-user should not have access to.
You could run the backup as postgres and pipe the output to another
program owned by the other user and with suid set in its permissions.
The suid means that the receiving program would have access where you
don't want postgres to go.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html