Florian Weimer a écrit : > 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)? > Nope. The only way you can look at data on a "on-recovery" server (the log shipping slave) is to stop the recovery process. > 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.) > Yes. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
