Oracle has a configuration option for its version of hot standby (DataGuard) that lets you specify a time based delay in applying logs. They get transferred right away, but changes in them are only applied as they reach a certain age. The idea is that if something horrible happens on the master, you can keep it from propagating to one or more of your standby databases (or keep from having to reinstate one in the case of a failover) Anyway, Is there any plan to add a knob like that to the streaming replication in Postgres? Hypothetically, if I had a standby database with max_standby_*_delay set to -1, and there had been a long running query so log apply was an hour behind, could I use that database for point in time recovery if something went wrong on the primary? Say something bad happened on primary, and I rushed over to the standby (in this delayed situation) and shut it down. Could I then alter the recovery.conf and have it come up read/write at a point in time? Seems like I could.... - Ian -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
