> > You have to run a new base backup and have the slave ship logs to the > master. Mmmm. Does this backup have to be a full backup? What if your database is very large? I am hoping to get a setup which is similar to SQL server mirroring. It uses a witness server to keep track of who got what "logs" (it's based on transaction logging) and allows you to failover and fail back without having to do a full backup in between. >> Is there a product which enables this kind of functionality? >> > > https://projects.commandprompt.com/public/pitrtools > I'll check these out. Thanks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general