Re: [GENERAL] Using pg_dump and pg_restore

2006-04-18 Thread Tom Lane
Mark <[EMAIL PROTECTED]> writes: > So far we have tried normal switches on the end of pg_dump, including > -Fc, -c, C, with corresponding switches on the pg_restore command. When > the restore actually executes, it does not fully drop the DB prior to > restoration so any test tables added to th

[GENERAL] Using pg_dump and pg_restore

2006-04-18 Thread Mark
Hi I am looking for some help here. I have 2 servers, one as master and one as a "warm spare". The master server runs 4 postgres DBs. Our intention (until we can get full replication and syncing between postgres DBs) is to regularly dump all DBs on the master, copy them to the warm spare