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