Well look at the utilities pg_dump pg_dumpall pg_restore psql Also read: http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=backup.html
I wrote some other nifty stuff that might help at: http://www.edoceo.com/liberum look for docs with PostgreSQL in the name. Anyhow, I've got a system that works very similar fashion. I use the script (on edoceo) to backup the database to two files, then gzip and rsync the files to my backup server. The backup server then gets told to drop backup DB, gunzip the files, create DB, import schema, import data. I'm using a plain text file backup. If you've got larger databases then you'll probablly want to dump into the binary format to save spacetime. You might also want to look at usogres a replication tool for PostgreSQL http://usogres.good-day.net/ /B ----- Original Message ----- From: "Andy Elacion, Jr." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Martin Marques" <[EMAIL PROTECTED]> Sent: Tuesday, March 04, 2003 00:45 Subject: Postgres daily back-up > Good day, > > We are planning to do a grand-father/father/son back-up (from live-db) > and restore (it to master-db) our daily transaction, then delete/purge > the data (on our live). According to our DBA, postgreSQL is not capable > of doing it, and I don't agree with him. > > Is there a way to implement our plan? Sample script,documentation or > web site on how to do this is highly appreciated. > > Thank you very much. > > > > > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED] > https://listman.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
