Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 17EE9650140
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 10 Dec 2008 08:40:50 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 18704-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 10 Dec 2008 08:40:44 -0400 (AST)
X-Greylist: delayed 00:17:04.966235 by SQLgrey-1.7.6
Received: from secondary-mx.mail.bg (secondary-mx.mail.bg [193.201.172.126])
	by mail.postgresql.org (Postfix) with ESMTP id 4D23B65013E
	for <pgsql-admin@postgresql.org>; Wed, 10 Dec 2008 08:40:44 -0400 (AST)
Received: from localhost (unknown [10.0.0.192])
	by secondary-mx.mail.bg (Postfix) with ESMTP id F04914B9C3
	for <pgsql-admin@postgresql.org>; Wed, 10 Dec 2008 14:23:35 +0200 (EET)
Received: from unisoft.unisoftbg.com (unisoft.unisoftbg.com
	[194.12.229.193]) by mail.bg (Horde MIME library) with HTTP; Wed, 10 Dec
	2008 14:23:35 +0200
Message-ID: <20081210142335.s2y9d3bcw0kwkcw0@mail.bg>
Date: Wed, 10 Dec 2008 14:23:35 +0200
From: zz_11@mail.bg
To: pgsql-admin@postgresql.org
Subject: warm standby server
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_5n0snkf06jok"
Content-Transfer-Encoding: 7bit
User-Agent: Mail.BG Webmail H3 (4.1.4)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.82 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001, MIME_QP_LONG_LINE=1.819
X-Spam-Level: *
X-Archive-Number: 200812/93
X-Sequence-Number: 30926

This message is in MIME format.

--=_5n0snkf06jok
Content-Type: text/plain; charset=windows-1251; DelSp="Yes"; format="flowed"
Content-Description: =?windows-1251?b?0uXq8fLu4uAg?=
	=?windows-1251?b?4uXw8ej/IA==?= =?windows-1251?b?7eAg?=
	=?windows-1251?b?7+jx7O7y7g==?=
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi,

I am using pg 8.3 and configured warm standby server. It is working =20
well, but my db is relative big ( ~ 40 GB).

Is it possible to stop running ?"Warm standby server" and? when it =20
starts again to continue executing WALs from the stop moment.

  I'm using following command to stop the server:

  kill -SIGINT `head -1 /POSTGRESQL_DATA_DIR/postmaster.pid`

  but when it starts again there is broken link =20
"/POSTGRESQL_DATA_DIR/pg_xlog/RECOVERYHISTORY" which points to the =20
following missing file "/WAL_ARCHIVE_DIR/00000001.history"

  i wonder if it is fatal or not?
  I will not to start the process ot making the base backup and send =20
it to my warm standby server. My warm standby server is on diferent =20
location connected via slow connection.
  regards, Ivan.


-------------------------------------

=D1=FA=E7=E4=E0=E9 =EF=F0=EE=F4=E8=EB =E4=ED=E5=F1 =E8 =EC=EE=E6=E5=F8 =E4=
=E0 =F1=EF=E5=F7=E5=EB=E8=F8 =E1=E5=E7=EF=EB=E0=F2=E5=ED =F1=E0=EC=EE=EB=E5=
=F2=E5=ED =E1=E8=EB=E5=F2 =E7=E0 =CB=EE=ED=E4=EE=ED!
=C2=FA=E7=EF=EE=EB=E7=E2=E0=E9 =F1=E5 =EE=F2 =ED=E0=F8=E8=F2=E5 =ED=E0=EC=E0=
=EB=E5=ED=E8=FF =E7=E0 =CD=EE=E2=E0 =C3=EE=E4=E8=ED=E0.=CA=F0=E0=E9=ED=E8=FF=
=F2 =F1=F0=EE=EA =ED=E0=E1=EB=E8=E6=E0=E2=E0-
=EF=EE=E1=FA=F0=E7=E0=E9=F2e!=D1=E0=EC=EE =F1=E5=E3=E0=96=EF=F0=EE=EC=EE=F6=
=E8=EE=ED=E0=EB=ED=E8 =F6=E5=ED=E8 =E8 =ED=E0 =D1=F2=F3=E4=E5=ED=F2=F1=EA=E8=
=F2=E5 =ED=E8 =EF=F0=EE=E3=F0=E0=EC=E8 =E2 =D1=C0=D9!
  http://charter.bg/catalog/index.php

--=_5n0snkf06jok
Content-Type: text/html;
	charset=windows-1251
Content-Description: HTML =?windows-1251?b?wuXw8ej/IA==?=
	=?windows-1251?b?7eAg?= =?windows-1251?b?8fru4fnl7ejl8u4=?=
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi,<br />
&nbsp;<br />
I am using pg 8.3 and configured warm standby server. It is working well, bu=
t my
db is relative big ( ~ 40 GB).<br />
&nbsp;<br />
<div class=3D"moz-text-html" lang=3D"x-unicode">Is it possible to stop runni=
ng
&#65279;"Warm standby server" and&#65279; when it starts again to continue
executing WALs from the stop moment.<br /> <br /> I'm using following comman=
d to
stop the server:<br /> &nbsp;&nbsp;&nbsp; <br /> <tt>kill -</tt>SIGINT<tt> `=
head
-1 /POSTGRESQL_DATA_DIR/postmaster.pid`</tt><br /> <br /> but when it starts
again there is broken link
"<tt>/POSTGRESQL_DATA_DIR</tt>/pg_xlog/RECOVERYHISTORY" which points to the
following missing file "/WAL_ARCHIVE_DIR/00000001.history"<br /> <br /> i wo=
nder
if it is fatal or not?</div>
<div class=3D"moz-text-html" lang=3D"x-unicode"><br /></div>
<div class=3D"moz-text-html" lang=3D"x-unicode">I will not to start the proc=
ess ot
making the base backup and send it to my warm standby server. My warm standb=
y
server is on diferent location connected via slow connection.</div>
<div class=3D"moz-text-html" lang=3D"x-unicode"><br /></div>
<div class=3D"moz-text-html" lang=3D"x-unicode">regards,</div>
<div class=3D"moz-text-html" lang=3D"x-unicode">Ivan.<br /></div><br /><br /=
>-------------------------------------<br /><a href=3D"http://mail.bg/ads/ww=
w/delivery/ck.php?oaparams=3D2__bannerid=3D2635__zoneid=3D17__cb=3De9f87c81b=
4__maxdest=3Dhttp://charter.bg/catalog/index.php">
=D1=FA=E7=E4=E0=E9 =EF=F0=EE=F4=E8=EB =E4=ED=E5=F1 =E8 =EC=EE=E6=E5=F8 =E4=
=E0 =F1=EF=E5=F7=E5=EB=E8=F8 =E1=E5=E7=EF=EB=E0=F2=E5=ED =F1=E0=EC=EE=EB=E5=
=F2=E5=ED =E1=E8=EB=E5=F2 =E7=E0 =CB=EE=ED=E4=EE=ED!<br />
=C2=FA=E7=EF=EE=EB=E7=E2=E0=E9 =F1=E5 =EE=F2 =ED=E0=F8=E8=F2=E5 =ED=E0=EC=E0=
=EB=E5=ED=E8=FF =E7=E0 =CD=EE=E2=E0 =C3=EE=E4=E8=ED=E0.=CA=F0=E0=E9=ED=E8=FF=
=F2 =F1=F0=EE=EA =ED=E0=E1=EB=E8=E6=E0=E2=E0-<br />
=EF=EE=E1=FA=F0=E7=E0=E9=F2e!=D1=E0=EC=EE =F1=E5=E3=E0=96=EF=F0=EE=EC=EE=F6=
=E8=EE=ED=E0=EB=ED=E8 =F6=E5=ED=E8 =E8 =ED=E0 =D1=F2=F3=E4=E5=ED=F2=F1=EA=E8=
=F2=E5 =ED=E8 =EF=F0=EE=E3=F0=E0=EC=E8 =E2 =D1=C0=D9!<br />
</a>
--=_5n0snkf06jok--