There is not such a possibility. However it's on TODO list:
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(dot)(dot)(dot)(at)bfk(dot)de (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(dot)(dot)(dot)(at)bfk(dot)de>
> 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(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin
In response to
pgsql-admin by date
|Next:||From: Guillaume Lelarge||Date: 2008-10-20 08:09:19|
|Subject: Re: Strategies for validating WAL-shipping replication|
|Previous:||From: Florian Weimer||Date: 2008-10-20 06:31:08|
|Subject: Strategies for validating WAL-shipping replication|