Lamar Owen wrote:
...
>2.) Use the command: pg_dumpall. Run this as postgres nightly. As an
>example, here is my crontab entry (substitute your PGDATA for
>"/var/lib/pgsql"):
>
>30 1 * * * pg_dumpall -o >/var/lib/pgsql/db.bak
>45 1 * * * cp /var/lib/pgsql/db.bak /var/lib/pgsql/db.bak.old
>
>This does a backup, then, 15 minutes later (which has always been enough
>time), it makes another copy of the file.
Just in case 15 minutes might not be enough, why not do this:
30 1 * * * pg_dumpall -o >/var/lib/pgsql/db.bak && cp /var/lib/pgsql/db.bak
/var/lib/pgsql/db.bak.old
so that the copy takes place immediately upon the successful completion of
pg_dumpall.
--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Finally, all of you, live in harmony with one another;
be sympathetic, love as brothers, be compassionate and
humble. Do not repay evil for evil or insult for
insult, but with blessing, because to this you were
called so that you may inherit a blessing."
I Peter 3:8,9
