From: Rural Hunter <ruralhunter@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Warm standby terminate itself?
Date: Wed, 21 Sep 2011 00:48:03 +0800
Message-ID: <4E78C3C3.5040208@gmail.com> (raw)
Hi,
I set up an warm standby server which fetches WAL logs from a remote
server. It has been working very well. But today, I was editing the
restore script(which is set as the restore_command) with vi. Just right
after I saved the script, I noticed suddenly the standby server
terminated. I checked log and only found these:
scp: /dbbk/postgres/logarch/0000000100000079000000B3.gz: No such file or
directory #this is in my script and it unzip the WAL log if it exists
2011-09-20 23:56:50 CST FATAL: could not restore file
"0000000100000079000000B3" from archive: return code 65280
2011-09-20 23:56:51 CST LOG: startup process (PID 2153) exited with
exit code 1
2011-09-20 23:56:51 CST LOG: terminating any other active server processes
I believe the script doesn't exit with 0 for any error(and it has been
working smoothly without any modification after server restart). After I
started the server, it just restored passing the file without problem
and it can live with file "No such file" warning because the master
server hasn't generated the log yet. I have no idea why the restore
failed. But even the restore fails, why it lead to a server crash(looks
like so)?
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: ruralhunter@gmail.com
Subject: Re: Warm standby terminate itself?
In-Reply-To: <4E78C3C3.5040208@gmail.com>
* 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