Re: Suppress checking of chmod 700 on data-dir? - Mailing list pgsql-general

From Johannes Konert
Subject Re: Suppress checking of chmod 700 on data-dir?
Date
Msg-id 466E37A4.5070402@t3go.de
Whole thread Raw
In response to Re: Suppress checking of chmod 700 on data-dir?  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: Suppress checking of chmod 700 on data-dir?  (Kevin Hunter <hunteke@earlham.edu>)
List pgsql-general
Oliver Elphick wrote:
> 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.
Thanks Oliver,
that was a good hint. Suids are not working on bash-scripts, but with a
restricted entry in /etc/sudoers now the backup-user can execute a
copy-and-access-script to get the files from within PGDATA-dir.
Regards Johannes

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: When should I worry?
Next
From: "lhaj.merigh@gmail.com"
Date:
Subject: Create a table B with data coming from table A