I have a Debian server running PostgreSQL and I want to push a daily backup
from that server to another server. Although I think I know how many of the
pieces work to make this happen I don't know how to put it all together in a
nice Debian way.
Where should I put the bash script that will do the work of making the backup
and pushing the backup to another server? I think this script must run as the
`postgres` user.
One thing I really like about my production server is that the only things I
ever did with root to set it up were install some packages with apt-get, create
one non-root user, create one database, and create one symbolic link for apache
configuration. Everything else I did was as that non-root user. So I'd really
like to keep the creation of this cron backup system as clean and simple as
possible.
Thanks!
#F00
