Stopping during recovery

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16981" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi, I've successfully set up a slave =
system using
WAL archiving and pg_standby, but I have a couple of =
questions.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a couple of =
questions:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>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?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Secondly is it possible to start the =
database in
"readonly" (using set default_transaction_read_only) and make a query =
before
resuming the recovery?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>John</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>--</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Got needs? Get Goblin'! - <A
href=3D"http://www.pricegoblin.co.uk/">http://www.pricegobli n.co.uk/</A><=
BR></FONT></DIV></BODY></HTML>

------=_NextPart_000_006B_01CACA7A.956733F0--
John Lister [ Di, 23 März 2010 12:18 ] [ ID #2036068 ]

Re: Stopping during recovery

--0016e6d99ead2b2a1604827674e0
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Mar 23, 2010 at 7:18 AM, John Lister
<john.lister-ps [at] 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-monitorin g
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

<div class=3D"gmail_quote">On Tue, Mar 23, 2010 at 7:18 AM, John Lister <sp=
an dir=3D"ltr"><<a href=3D"mailto:john.lister-ps [at] kickstone.com">john.lis=
ter-ps [at] kickstone.com</a>></span> wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
;">






<div bgcolor=3D"#ffffff">
<div><font face=3D"Arial" size=3D"2">Hi, I've successfully set up a sla=
ve system using
WAL archiving and pg_standby, but I have a couple of questions.</font></div=
>
<div><font face=3D"Arial" size=3D"2"></font>=A0</div>
<div><font face=3D"Arial" size=3D"2">I have a couple of questions:</font></=
div>
<div><font face=3D"Arial" size=3D"2"></font>=A0</div>
<div><font face=3D"Arial" size=3D"2">Is it possible to stop the database se=
rver (for
maintenance for example) and resume the recovery without starting afresh an=
d
making a complete backup of the original again?</font></div></div></blockqu=
ote><div><br></div><div>Yes, it won't begin reading at the very first l=
ogfile, it will start based on your last checkpoint:</div><div><br></div>
<div>=A0=A0<a href=3D"http://www.scottrmead.com/blogs/scott/warm-standby-mo=
nitoring">http://www.scottrmead.com/blogs/scott/warm-standby -monitoring</a>=
</div><div>=A0=A0<a href=3D"http://www.kennygorman.com/wordpress/?p=3D249">=
http://www.kennygorman.com/wordpress/?p=3D249</a></div>
<div><br></div><div>=A0</div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div bgcolor=
=3D"#ffffff">
<div><font face=3D"Arial" size=3D"2">Secondly is it possible to start the d=
atabase in
"readonly" (using set default_transaction_read_only) and make a q=
uery before
resuming the recovery?</font></div></div></blockquote><div><br></div><div>N=
o, this feature is only available in 9.0 (which is in alpha) and beyond.</d=
iv><div><br></div><div>--Scott M</div></div>

--0016e6d99ead2b2a1604827674e0--
Scott Mead [ Di, 23 März 2010 12:52 ] [ ID #2036069 ]
Datenbanken » gmane.comp.db.postgresql.admin » Stopping during recovery

Vorheriges Thema: Supported Platforms for pgbouncer ?
Nächstes Thema: Backup&Restore Postgres DB

[ Startseite ] [ Administrator ] [ Suche ] [ Hinweise ] [ Impressum ]

Powered by FudForum