[linux] Backup Scripts using rsync and pg_dump

[Toshimi Minoura]

Hi,

We are creating cron jobs to backup directories and
PostgreSQL databases on remote machines.

What we do not know are the following.

1) How to pass a password to rsyncd on the remote site.

2) How to execute pg_dump on the remote site and store 
   the output in a file on the local site.
   
   I know how to use pg_dump and how to pass a password to it
   by using .pg_pass.
   
   However, pg_dump on the local site cannot be used to dump
   a database on the remote site since the versions
   of PostgreSQl on the remote and local sites are different.
   
   The problem can be solved if I know how to execute pg_dump
   on the remote site and how to pipe its output to a local file.

Toshi