>>> Simon Riggs <si...@2ndquadrant.com> wrote: > There are considerable benefits to having it turned on during PITR > > Please read this to see why > http://wiki.postgresql.org/wiki/Hot_Standby#Dynamic_Control_of_Recovery Am I reading this right? What I get out of it is that users can connect to the database during recovery, like with psql or JDBC? Any user can query recovery completion status and progress, while a superuser can also step through transactions in various ways? Can the data in the database be queried while recovery is paused? If I'm understanding this, and data can be queried during a pause, I can certainly see use cases for this; but it might be important to be able to start the recovery in a paused state to avoid going too far in the transaction stream before a connection can be established and recovery paused. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
