From: zz_11@mail.bg
To: pgsql-admin@postgresql.org
Subject: warm standby server
Date: Wed, 10 Dec 2008 14:23:35 +0200
Message-ID: <20081210142335.s2y9d3bcw0kwkcw0@mail.bg> (raw)
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.
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
"/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?
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.
regards, Ivan.
-------------------------------------
Създай профил днес и можеш да спечелиш безплатен самолетен билет за Лондон!
Възползвай се от нашите намаления за Нова Година.Крайният срок наближава-
побързайтe!Само сега–промоционални цени и на Студентските ни програми в САЩ!
http://charter.bg/catalog/index.php
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: zz_11@mail.bg
Subject: Re: warm standby server
In-Reply-To: <20081210142335.s2y9d3bcw0kwkcw0@mail.bg>
* 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