pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedShould data directories match between master and hot standby?
2+ messages / 1 participants
[nested] [flat]
* Should data directories match between master and hot standby?
@ 2012-10-03 20:01 Brian Fehrle <brianf@consistentstate.com>
0 siblings, 1 reply; 2+ messages in thread
From: Brian Fehrle @ 2012-10-03 20:01 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Should data directories match between master and hot standby?
@ 2012-10-03 20:48 Brian Fehrle <brianf@consistentstate.com>
parent: Brian Fehrle <brianf@consistentstate.com>
0 siblings, 0 replies; 2+ messages in thread
From: Brian Fehrle @ 2012-10-03 20:48 UTC (permalink / raw)
To: pgsql-admin
Hi all,
Looks like I found the reason. There is a huge query on the slave that
has been running for 5 hours. It's doing major sorting and has claimed
29 gigs in the base/pgsql_tmp/ directory, which is the excact
discrepancy between the master and the slave.
So makes sense, I'm good,
- Brian F
On 10/03/2012 02:01 PM, Brian Fehrle wrote:
> 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
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-10-03 20:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-03 20:01 Should data directories match between master and hot standby? Brian Fehrle <brianf@consistentstate.com>
2012-10-03 20:48 ` Brian Fehrle <brianf@consistentstate.com>
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