Re: Wal files being delayed - Pgsql 9.2

2016-11-14 15:33 GMT+13:00 Venkata B Nagothi <nag1010(at)gmail(dot)com>:

>
> On Mon, Nov 14, 2016 at 1:22 PM, Patrick B <patrickbakerbr(at)gmail(dot)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!