Richard, > Use scp. Open port 22 and allow only connections from the backup machine > with a specified user (e.g. "pgbackup"). > > Alternatively, you might try dumping in a text-format and using rsync to > transfer changes. I really do'nt want to open separate port for backup only. Pelase, can you recomment a solution which uses port 5432 owned by Postgres ? >> pg_read_file() can read only text files and is restricted only to >> superusers. >> >> How to add a function pg_read_backup() to Postgres which creates and >> returns backup file with download speed ? >> This problably requires implementing some file download protocol. > > Just don't try and do it within PG - use the tools the system provides. How to force postmaster to run the tool which system provides when it receives backup request instead of postgres child process ? Andrus.
