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 


Reply via email to