Wal files being delayed - Pgsql 9.2

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.

Responses

Browse pgsql-general by date

  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