From: Ray Stell <stellr@cns.vt.edu>
To: Yauheni Labko <yyl@chappy.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: standby waiting for what?
Date: Thu, 5 Mar 2009 14:52:49 -0500
Message-ID: <20090305195249.GC1068@cns.vt.edu> (raw)
In-Reply-To: <200903051004.44932.yyl@chappy.com>
References: <20090304200612.GA25611@cns.vt.edu>
<200903041705.19794.yyl@chappy.com>
<20090305135556.GA9900@cns.vt.edu>
<200903051004.44932.yyl@chappy.com>
On Thu, Mar 05, 2009 at 10:04:44AM -0500, Yauheni Labko wrote:
> You gave the recovery command, not the archive command.
I'm curious why you are focused on the archive on the primary?
Is there some logic in the archive process that could cause the recovery to
be looking for /data/pgsql/wals/alerts_oamp/00000002000000000000001C.00512178.backup ?
That doesn't make any sense to me. Are they not two completely seperate
worlds or does the archive command somehow determine what
args go pg_standby?
The archive command is set to:
archive_command = '/home/postgresql/bin/archive.sh %p %f alerts_oamp'
that script in essence echos some debug values and rsyncs the WAL file
over.
echo "src - $SRC"
echo "destname - $NAME"
rsync --links -e 'ssh -c blowfish -ax' -avz "${SRC}" "${STBY}:${STBYDIR}/${NAME}"
Again, those files look fine on the standby, the names are identical to
those in the primary pg_xlogs. So, please explain your reasoning.
> And give a piece of
> log file where primary server performs archiving WAL files.
src - /data/pgsql/alerts_oamp/pg_xlog/00000002000000000000001F
destname - 00000002000000000000001F
Authorized use only! All sessions may be monitored or recorded.
building file list ... done
00000002000000000000001F
sent 4211135 bytes received 42 bytes 935817.11 bytes/sec
total size is 16777216 speedup is 3.98
src - /data/pgsql/alerts_oamp/pg_xlog/000000020000000000000020
destname - 000000020000000000000020
Authorized use only! All sessions may be monitored or recorded.
building file list ... done
000000020000000000000020
sent 4750728 bytes received 42 bytes 863776.36 bytes/sec
total size is 16777216 speedup is 3.53
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: stellr@cns.vt.edu, yyl@chappy.com
Subject: Re: standby waiting for what?
In-Reply-To: <20090305195249.GC1068@cns.vt.edu>
* 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