From john.lister-ps@kickstone.com Tue Mar 23 11:40:47 2010 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B8161632520 for ; Tue, 23 Mar 2010 08:40:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94187-01-6 for ; Tue, 23 Mar 2010 11:40:36 +0000 (UTC) X-Greylist: delayed 00:21:56.202077 by SQLgrey-1.7.6 Received: from mail.kickstone.com (smtp.kickstone.com [87.194.183.70]) by mail.postgresql.org (Postfix) with ESMTP id 327DA634300 for ; Tue, 23 Mar 2010 08:40:37 -0300 (ADT) Received: from 87-194-183-69.dsl.cnl.uk.net ([87.194.183.69]:3723 helo=MADRAS2) by mail.kickstone.com with esmtpa (Exim 4.69) (envelope-from ) id 1Nu27j-000505-8S for pgsql-admin@postgresql.org; Tue, 23 Mar 2010 11:18:15 +0000 Message-ID: From: "John Lister" To: Subject: Stopping during recovery Date: Tue, 23 Mar 2010 11:18:37 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006B_01CACA7A.956733F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5843 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.184 tagged_above=-10 required=5 tests=BAYES_40=-0.185, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/165 X-Sequence-Number: 33964 This is a multi-part message in MIME format. ------=_NextPart_000_006B_01CACA7A.956733F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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/ ------=_NextPart_000_006B_01CACA7A.956733F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi, I've successfully set up a slave = system using=20 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=20 maintenance for example) and resume the recovery without starting afresh = and=20 making a complete backup of the original again?
Secondly is it possible to start the = database in=20 "readonly" (using set default_transaction_read_only) and make a query = before=20 resuming the recovery?
 
Thanks
 
John
--
 
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/<= BR>
------=_NextPart_000_006B_01CACA7A.956733F0-- From scott.lists@enterprisedb.com Tue Mar 23 12:01:13 2010 Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 238BB63241A for ; Tue, 23 Mar 2010 09:01:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 68827-03 for ; Tue, 23 Mar 2010 12:00:46 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og125.obsmtp.com (exprod7og125.obsmtp.com [64.18.2.28]) by mail.postgresql.org (Postfix) with SMTP id 9B5216321C4 for ; Tue, 23 Mar 2010 09:00:06 -0300 (ADT) Received: from source ([74.125.82.174]) by exprod7ob125.postini.com ([64.18.6.12]) with SMTP ID DSNKS6itRGZlz79X8uUlON9PS6KRsSIuZxVC@postini.com; Tue, 23 Mar 2010 05:00:06 PDT Received: by mail-wy0-f174.google.com with SMTP id 38so2986086wyb.19 for ; Tue, 23 Mar 2010 05:00:04 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.87.67 with SMTP id x45mr274251wee.18.1269345173579; Tue, 23 Mar 2010 04:52:53 -0700 (PDT) In-Reply-To: References: Date: Tue, 23 Mar 2010 07:52:53 -0400 Message-ID: Subject: Re: Stopping during recovery From: Scott Mead To: John Lister Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016e6d99ead2b2a1604827674e0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.477 tagged_above=-10 required=5 tests=AWL=0.121, BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/166 X-Sequence-Number: 33965 --0016e6d99ead2b2a1604827674e0 Content-Type: text/plain; charset=ISO-8859-1 On Tue, Mar 23, 2010 at 7:18 AM, John Lister 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 --0016e6d99ead2b2a1604827674e0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Tue, Mar 23, 2010 at 7:18 AM, John Lister <john.lis= ter-ps@kickstone.com> wrote:
Hi, I've successfully set up a sla= ve system using=20 WAL archiving and pg_standby, but I have a couple of questions.
=A0
I have a couple of questions:
=A0
Is it possible to stop the database se= rver (for=20 maintenance for example) and resume the recovery without starting afresh an= d=20 making a complete backup of the original again?

Yes, it won't begin reading at the very first l= ogfile, it will start based on your last checkpoint:


=A0
Secondly is it possible to start the d= atabase in=20 "readonly" (using set default_transaction_read_only) and make a q= uery before=20 resuming the recovery?

N= o, this feature is only available in 9.0 (which is in alpha) and beyond.

--Scott M
--0016e6d99ead2b2a1604827674e0--