pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Stopping during recovery 2+ messages / 2 participants [nested] [flat]
* Stopping during recovery @ 2010-03-23 11:18 John Lister <john.lister-ps@kickstone.com> 2010-03-23 11:52 ` Re: Stopping during recovery Scott Mead <scott.lists@enterprisedb.com> 0 siblings, 1 reply; 2+ messages in thread From: John Lister @ 2010-03-23 11:18 UTC (permalink / raw) To: pgsql-admin 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/ ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Stopping during recovery 2010-03-23 11:18 Stopping during recovery John Lister <john.lister-ps@kickstone.com> @ 2010-03-23 11:52 ` Scott Mead <scott.lists@enterprisedb.com> 0 siblings, 0 replies; 2+ messages in thread From: Scott Mead @ 2010-03-23 11:52 UTC (permalink / raw) To: John Lister <john.lister-ps@kickstone.com>; +Cc: pgsql-admin On Tue, Mar 23, 2010 at 7:18 AM, John Lister <john.lister-ps@kickstone.com>wrote: > 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? > Yes, it won't begin reading at the very first logfile, it will start based on your last checkpoint: http://www.scottrmead.com/blogs/scott/warm-standby-monitoring http://www.kennygorman.com/wordpress/?p=249 > Secondly is it possible to start the database in "readonly" (using set > default_transaction_read_only) and make a query before resuming the > recovery? > No, this feature is only available in 9.0 (which is in alpha) and beyond. --Scott M ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-03-23 11:52 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-03-23 11:18 Stopping during recovery John Lister <john.lister-ps@kickstone.com> 2010-03-23 11:52 ` Scott Mead <scott.lists@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox