Wal files being delayed - Pgsql 9.2

On Mon, Nov 14, 2016 at 1:22 PM, Patrick B <patrickbakerbr@gmail.com> wrote:

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?

You can identify the file name by using the function pg_xlogfile_name().

"select pg_xlogfile_name('1A7C/14AEB2C0');"

Regards,

Venkata B N
Database Consultant

Fujitsu Australia

2016-11-14 15:33 GMT+13:00 Venkata B Nagothi <nag1010@gmail.com>:

On Mon, Nov 14, 2016 at 1:22 PM, Patrick B <patrickbakerbr@gmail.com>
wrote:

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?

You can identify the file name by using the function pg_xlogfile_name().

"select pg_xlogfile_name('1A7C/14AEB2C0');"

Thanks a lot!