Hi All, I am looking at implementing data backup for my database after implementing Slony 1.2.16 on PostgreSQL 8.1.18. My setup is a typical one with 1 master and 1 slave. Reading thru the documentation, I understand that using pg_dump on the master node will include details of the cluster config in the dump. Assuming I am looking at a daily dump of the database for backup purpose and for worst case scenario where all else fails. The slony documentation mention this slony1_extract_schema.sh script which I feel is rather risky to be running on a daily basis and resource consuming on a production server 1. Is there a procedure for simplfying the dumping of database without cluster information which can be run on a daily basis? 2. Can anyone share how you actually implement daily backup with Slony? 3. Lastly how is the restore procedure like?
Regards, Lawrence Giam <http://www.globalitcreations.com/> ........................................................................ .......................... Lawrence Giam | Global IT Creations Pte Ltd | Network Administrator website: http://www.globalitcreations.com <http://www.globalitcreations.com/> phone: +65 6836 4768 ext 115| fax: + 65 6836 4736 | mobile: + 65 9758 7448
<<gitclogo.jpg>>
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
