From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Wal files being delayed - Pgsql 9.2 |
Date: | 2016-11-14 02:22:24 |
Message-ID: | CAJNY3ismUT6UWtiTm8V9mSez5grjOt=VMnLKsxAGDieAuEtsBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guys,
My current scenario is:
master01 - Postgres 9.2 master DB
slave01 - Postgres 9.2 streaming replication + wal_files slave server for
read-only queries
slave02 - Postgres 9.2 streaming replication + wal_files slave server @ AWS
master01 sends wal_files to both slaves via ssh.
*On the master:*
select * from pg_current_xlog_location();
pg_current_xlog_location
--------------------------
1A7C/14AEB2C0
(1 row)
*On the slaves:*
ls -ltr /var/lib/pgsql/archive/
-rw------- 1 postgres postgres 16777216 Nov 14 01:21
0000000200001A7A000000F9
As you can see, the last wal_files on the slaves isn't the
0000000200001A7C* ones. I think the SSH delivery is being delayed. Not sure
why tho.
How can I see how many files are behind?
Cheers
Patrick.
From | Date | Subject | |
---|---|---|---|
Next Message | Venkata B Nagothi | 2016-11-14 02:33:50 | Re: Wal files being delayed - Pgsql 9.2 |
Previous Message | James Sewell | 2016-11-14 00:58:11 | Re: Sequential parallel scan / agg |