Search Postgresql Archives

Wal files being delayed - Pgsql 9.2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux