From: ethan@757.org
To: pgsql-admin@postgresql.org
Subject: Question, WAL file sequence on standby database? Always starts at 00?
Date: Wed, 19 Nov 2008 10:43:34 -0500 (EST)
Message-ID: <Pine.NEB.4.62.0811191037560.12544@users.757.org> (raw)
Hello all,
I've started to setup a standby database, following the good
official documentation. I've got WAL files archiving, I've got scripts
moving them to the standby, but no data in the standby.
I triggered a backup on the primary, which worked fine. The WAL files
appeared to be created.
But on the standby system, I can see that it is always trying to read in
the first file
LOG: could not open file "pg_xlog/000000010000000000000000" (log file 0, segment 0): No such file or directory
However, since I had the primary logging for a little while, the backup
is in a different file (0000000100000004000000D4)
I figure I'm missing something obvious, but googling around and
searching the mailing list archive isn't yeilding anything related to this
issue. My config is pretty straightforward, the recovery.conf file is
identical to the proposed one in the official docs.
I found that it's possible to force the primary to start over again but
I can see this being problematic in the future and it doesn't seem clean.
Any suggestions are welcome!
Platform is 8.2 on CentOS.
TIA
- Ethan
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: ethan@757.org
Subject: Re: Question, WAL file sequence on standby database? Always starts at 00?
In-Reply-To: <Pine.NEB.4.62.0811191037560.12544@users.757.org>
* 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