Alanoly Andrews <alanolya@xxxxxxxxxx> writes: > Hello, > > Is it possible to set up a warm standby pair of postgres instances > without using the pg_standby utility? The PG manuals appear to say it > is possible. But I dont see the details of how to set this up. How > do you keep the standby instance in permanent recovery mode? Certainly if you implement the same or possibly extended logic yourself in whatever language you are comfortable with. Myself and others have been doing warm-standby since WALs were invented :-) When the company I work for started requiring that WS servers be helf back a configurable time lag from production, I made some minor mods to our version of the standby script, now written in Python, to make it happen. WALs now have to pass sanity and aging checks before being applied. HTH -- Jerry Sievers Postgres DBA/Development Consulting e: gsievers19@xxxxxxxxxxx p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
