Jason Long <[EMAIL PROTECTED]> writes: > I need to set up master vs slave replication. > > My use case is quite simple. I need to back up a small but fairly > complex(30 MB data, 175 tables) DB remotely over T1 and be able to > switch to that if the main server fails. The switch can even be a > script run manually. > > Can someone either comment in as much detail as possible or point me > to a comparison of Slony vs Longiste. Or some other option I have not > heard of?
You can also consider using pg-pool[1] or sequioa[2] which will automatically handle high-availability if any of the servers fails. Regards. [1] http://pgpool.projects.postgresql.org/ [2] http://sequoia.continuent.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
