On Mar 26, 2015, at 12:17 PM, Graeme B. Bell <grb@xxxxxxxxxxxxxxxxx> wrote: > > ...I won't be able to directly apply the (promoted) standby's new WAL entries over the top of it. I see--there's our difference. When I do this, I am willing to stay on the standby for a while if need be. > A checkpoint or autovacuum might generate a small change/entry in WAL (I don't know this for sure regarding autovacuum; this is a worst case assumption). I would think autovacuum would have to, since it writes some changes to at least index pages. > Let's imagine someone follows your advice but is already running a PITR archive with archive_timeout. The recommended timeout is 1 minute. Every minute their server generates a new WAL segment. Yeah, I'm always assuming streaming replication. If you know you have a delay in replication, you'd better remember that ;-) -- 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
