Postgres Pro
Downloads
Home   >   mailing lists

Stopping during recovery - Mailing list pgsql-admin

From John Lister
Subject Stopping during recovery
Date
Msg-id FDE36E7833B84CDD810DC4A9F14DF40C@squarepi.com
Whole thread Raw
Responses Re: Stopping during recovery
List pgsql-admin
Tree view
Hi, I've successfully set up a slave system using WAL archiving and pg_standby, but I have a couple of questions.
 
I have a couple of questions:
 
Is it possible to stop the database server (for maintenance for example) and resume the recovery without starting afresh and making a complete backup of the original again?
Secondly is it possible to start the database in "readonly" (using set default_transaction_read_only) and make a query before resuming the recovery?
 
Thanks
 
John
--
 
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/

pgsql-admin by date:

Previous
From: "Steve Jones"
Date:
Subject: pg_stat: last vacuum and analyze times are not being updated - v8.3.5
Next
From: Scott Mead
Date:
Subject: Re: Stopping during recovery