There is not such a possibility. However it's on TODO list: http://wiki.postgresql.org/wiki/Todo I'm waiting for this feature too. I can understand your fear about the data, that you can not query for it. I had the same :) So script as much as you can, for the rest create a formal procedure - then repeat it few times and check if everything is correct. After several tries you'll believe your data are safe. I've a good comfort level with this. You can also check & resetup your production from time to time. On Oct 20, 8:31 am, fwei...@xxxxxx (Florian Weimer) wrote: > We've set up WAL-shipping replication on one of our database servers, > and the question is whether it runs correctly. Is there an easy way > to access some tables and see if the data matches (possibly in > single-user mode)? > > Stopping replication and starting the server for real on the replica > means that we have to set up things from scratch, right? (This is a > bit annoying because of the amount of data which has to be copied from > the master.) > > -- > Florian Weimer <fwei...@xxxxxx> > BFK edv-consulting GmbH http://www.bfk.de/ > Kriegsstraße 100 tel: +49-721-96201-1 > D-76133 Karlsruhe fax: +49-721-96201-99 > > -- > Sent via pgsql-admin mailing list (pgsql-ad...@xxxxxxxxxxxxxx) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
