Re: [GENERAL] Wal files being delayed - Pgsql 9.2

[Patrick B]

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

[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');"


Regards,

Venkata B N
Database Consultant

Fujitsu Australia

[GENERAL] Wal files being delayed - Pgsql 9.2

[Patrick B]

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.