Re: postgres hot-standby questions.

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "Graeme B(dot) Bell" <grb(at)skogoglandskap(dot)no>
Cc: Postgres Maillist <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres hot-standby questions.
Date: 2015-03-26 16:19:39
Message-ID: 7EE11DF8-A813-4B65-BFD2-B258C5A9D666@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mar 26, 2015, at 10:16 AM, Graeme B. Bell <grb(at)skogoglandskap(dot)no> wrote:
>
>
>> But try comparing pg_current_xlog_location on the master to pg_last_xlog_receive_location on the replica. You could also look into using the pg_stat_replication view.
>>
>
>
> This becomes challenging after the master is shutdown...

Right. Thus the need for the sequence I mentioned: shut down all services accessing the database, check the status, shut down the master...

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Graeme B. Bell 2015-03-26 16:38:39 Re: postgres hot-standby questions.
Previous Message Scott Ribe 2015-03-26 16:18:06 Re: postgres hot-standby questions.