[ADMIN] PostgreSQL Replication/Clustering solution

2003-01-30 Thread guillermo schulman
Hi you all. I'm asked to do a report about Replication/Clustering for PostgreSQL. I need to report about what kind of tools does exist and compare them, and finally propose a solution to implement in the company's database. I have a poor idea about replication/clustering issues (and about writin

[ADMIN] backup/restore and vacuumdb

2003-02-13 Thread guillermo schulman
I'm doing some migration script from mysql database to an existing postgresql database. Everytime I want to test it, I want to get the postgres "destination" database to the same situation it was before the last script was run. I am doing a backup with pgdump and restoring by droping the databas