Re: [ADMIN] Standby: Use WAL instead of Streaming for now - Mailing list pgsql-admin

From Don Seiler
Subject Re: [ADMIN] Standby: Use WAL instead of Streaming for now
Date
Msg-id CAHJZqBCPNxYF0BM8tXibiWYc9HJYKG+4_VnSH_1omOp8Z=UMLg@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Standby: Use WAL instead of Streaming for now  (Don Seiler <don@seiler.us>)
List pgsql-admin
Sorted it out thanks to the folks in IRC. I didn't change any configs, just killed the sender process on the primary via pg_terminate_backed() on the PID of the sender (as seen in pg_stat_replication). This caused recovery on the standby immediately fall back to WAL recovery, where it quickly restored and recovered all the WAL files I had copied over. Once it finished with those, it opened another streaming connection. So I'll just rinse/repeat this process until our networking issues are resolved.

Don.
--
Don Seiler
www.seiler.us

pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: Re: [ADMIN] Standby: Use WAL instead of Streaming for now
Next
From: Aleksander Kamenik
Date:
Subject: [ADMIN] Re: pg_current_xlog*_location and pg_stat_replication.replay_location> 0 for synced replication connection