From: Brian Fehrle <brianf@consistentstate.com>
To: pgsql-admin@postgresql.org
Subject: Should data directories match between master and hot standby?
Date: Wed, 03 Oct 2012 14:01:42 -0600
Message-ID: <506C99A6.2030708@consistentstate.com> (raw)
Hi all,
I have a hot standby (via streaming replication) set up on a postgresql
9.0.4 system.
(I'm looking at base to eliminate differences in xlog and pg_log, etc)
The size of my base directory on the master is 775G, the size of the
base directory on the hot standby is 804G.
Is this normal? Collecting the info from the master and the slave using
the following shows I'm in sync:
[on the master] select pg_current_xlog_location() ->
pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7282688)
[on the slave] select pg_last_xlog_receive_location() ->
pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7282688)
[on the slave] select pg_last_xlog_replay_location() ->
pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7281296)
So I'm in sync, not like the slave is waiting on a huge delete or anything.
Any thoughts or ideas what this could be?
Thanks in advance,
- Brian F
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: brianf@consistentstate.com
Subject: Re: Should data directories match between master and hot standby?
In-Reply-To: <506C99A6.2030708@consistentstate.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