On Thu, Apr 14, 2011 at 1:06 PM, Alanoly Andrews <alanolya@xxxxxxxxxx> wrote: > Thanks, Simon, for your quick response. I'll try it out with your pg_standby utility. And...if I may ask you one more question on the subject, once the standby is up and running, is there a way to determine whether it is in synch with the primary database (in terms of the last WAL applied)? I guess that the standby cannot be queried as it would be in permanent recovery mode. At 8.4, no, you cannot query the standby. 9.0 introduces the Hot Standby feature to allow you to query the standby. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
