From: Gerardo Herzig <gherzig@fmed.uba.ar>
To: SQL Postgresql List <pgsql-sql@postgresql.org>
Subject: WAL archiving blowed.
Date: Thu, 03 Jan 2008 16:33:57 -0300
Message-ID: <477D38A5.7040008@fmed.uba.ar> (raw)
Hi all. Im trying to set a Standby server for HA. I have set the program
to copy the WAL files to the standby server, but because im so stupid,
for some stupid reason i delete those files from the standby server, and
now, when i set the recovery_command at the standby server, it tells me that
"cant get 'stat' over 00000000010000000000: No such file. "
I guess i have at least 2 easy options:
1) Telling the master server to restart the file naming procedure, and
2) Telling the standby server which is the 'first' filename to recover from.
But cant find information about this 2 options
Any clues?
Thanks!
Gerardo
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-sql@postgresql.org
Cc: gherzig@fmed.uba.ar
Subject: Re: WAL archiving blowed.
In-Reply-To: <477D38A5.7040008@fmed.uba.ar>
* 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