From: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
---|---|
To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Wal files being delayed - Pgsql 9.2 |
Date: | 2016-11-14 02:33:50 |
Message-ID: | CAEyp7J-t8ph=v1Z6UQgNByF2DW7qtHDbbmX7X=D1P2Tt6bQFzw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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');"
Regards,
Venkata B N
Database Consultant
Fujitsu Australia
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Lewis | 2016-11-14 03:50:47 | Re: Why is this query not using GIN index? |
Previous Message | Patrick B | 2016-11-14 02:22:24 | Wal files being delayed - Pgsql 9.2 |