Re: How to implement backup protocol

Andrus wrote:
> 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
> ?

No.

You seem dead set on making your life harder than it needs to be. If you
really don't want to have the ssh port open then set the backup to run
from a cron-job on the main server and have it scp the result over to
the backup server. That way only the backup server needs ssh open.

>>> 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 ?

Don't. You're just making life difficult for yourself. Use the standard
Unix solution for such things - ssh.

How are you installing updates without ssh access to the server?

--
Richard Huxton
Archonet Ltd