From: Simon Riggs <simon@2ndQuadrant.com>
To: zz_11@mail.bg
Cc: pgsql-admin@postgresql.org
Subject: Re: warm standby server
Date: Wed, 10 Dec 2008 17:56:11 +0000
Message-ID: <1228931771.20796.875.camel@hp_dx2400_1> (raw)
In-Reply-To: <20081210142335.s2y9d3bcw0kwkcw0@mail.bg>
References: <20081210142335.s2y9d3bcw0kwkcw0@mail.bg>
On Wed, 2008-12-10 at 14:23 +0200, zz_11@mail.bg wrote:
> Hi,
>
> I am using pg 8.3 and configured warm standby server. It is working
> well, but my db is relative big ( ~ 40 GB).
>
> Is it possible to stop running "Warm standby server" and when it
> starts again to continue executing WALs from the stop moment.
Yes
> I'm using following command to stop the server:
>
> kill -SIGINT `head -1 /POSTGRESQL_DATA_DIR/postmaster.pid`
Use pg_ctl
> but when it starts again there is broken link
> "/POSTGRESQL_DATA_DIR/pg_xlog/RECOVERYHISTORY" which points to the
> following missing file "/WAL_ARCHIVE_DIR/00000001.history"
>
> i wonder if it is fatal or not?
That's normal.
> I will not to start the process ot making the base backup and send it
> to my warm standby server. My warm standby server is on diferent
> location connected via slow connection.
That's OK.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndQuadrant.com, zz_11@mail.bg
Subject: Re: warm standby server
In-Reply-To: <1228931771.20796.875.camel@hp_dx2400_1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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