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 [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
