| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Alanoly Andrews <alanolya(at)invera(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Warm Standby on 8.4.7 |
| Date: | 2011-04-14 14:52:15 |
| Message-ID: | BANLkTi=W0s-Mao6q5bj7i+MYx0iykgSayw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Apr 14, 2011 at 1:06 PM, Alanoly Andrews <alanolya(at)invera(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Sotto Maior (SIM) | 2011-04-14 19:07:57 | RES: 20110408pg upgrade fix: How do I know if I am being affected before errors occur |
| Previous Message | Jerry Sievers | 2011-04-14 11:13:19 | Re: Warm Standby on 8.4.7 |