Re: postgres hot-standby questions. - Mailing list pgsql-admin

From Scott Ribe
Subject Re: postgres hot-standby questions.
Date
Msg-id 7EE11DF8-A813-4B65-BFD2-B258C5A9D666@elevated-dev.com
Whole thread Raw
In response to postgres hot-standby questions.  ("Graeme B. Bell" <grb@skogoglandskap.no>)
Responses Re: postgres hot-standby questions.  ("Graeme B. Bell" <grb@skogoglandskap.no>)
List pgsql-admin
On Mar 26, 2015, at 10:16 AM, Graeme B. Bell <grb@skogoglandskap.no> wrote:
>
>
>> But try comparing pg_current_xlog_location on the master to pg_last_xlog_receive_location on the replica. You could
alsolook 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,
shutdown the master... 

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







pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: postgres hot-standby questions.
Next
From: Scott Ribe
Date:
Subject: Re: postgres hot-standby questions.