Re: Standby: Use WAL instead of Streaming for now

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux