On Mar 26, 2015, at 10:16 AM, Graeme B. Bell <grb@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
