Re: [GENERAL] Wal files being delayed - Pgsql 9.2
2016-11-14 15:33 GMT+13:00 Venkata B Nagothi : > > On Mon, Nov 14, 2016 at 1:22 PM, Patrick B > 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 >> 00021A7A00F9 >> >> >> As you can see, the last wal_files on the slaves isn't the >> 00021A7C* 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!
Re: [GENERAL] Wal files being delayed - Pgsql 9.2
On Mon, Nov 14, 2016 at 1:22 PM, Patrick B 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 > 00021A7A00F9 > > > As you can see, the last wal_files on the slaves isn't the > 00021A7C* 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
[GENERAL] Wal files being delayed - Pgsql 9.2
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 00021A7A00F9 As you can see, the last wal_files on the slaves isn't the 00021A7C* ones. I think the SSH delivery is being delayed. Not sure why tho. How can I see how many files are behind? Cheers Patrick.