From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Patrick B <patrickbakerbr(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Question about wal files / pg_xlogs |
Date: | 2016-08-04 02:45:49 |
Message-ID: | c139e4e1-bd9d-e99b-24e4-47a0f0143577@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/03/2016 07:21 PM, Patrick B wrote:
> Hi all,
>
> I'm currently using PostgreSQL 9.2. I noticed that the wal_files are
> being generated by the master well, no problems. But on the slaves, it
> seems to be a delay to the delivery of those wal_files.
>
> I got two slaves using streaming replication and wal files shipment from
> Master.
>
> *On the master:*
>
> ls -ltr /var/lib/pgsql/9.2/data/pg_xlogs/
> Aug 4 02:18 000000020000159D000000D1
> Aug 4 02:18 000000020000159D000000D2
> Aug 4 02:18 000000020000159D000000D3
>
>
> select * from pg_current_xlog_location();
> 159D/D6C8DAF8
>
>
> So, seems to be ok.
>
>
> *On the slave:*
>
>
> ls -ltr /var/lib/pgsql/9.2/wal_archive:
> Aug 4 00:58 000000020000159C00000071
> Aug 4 00:58 000000020000159C00000072
> Aug 4 00:58 000000020000159C00000073
>
>
> See the time difference? 2 hours? It seems the files are being delivered
> with 2 hours delay.
Both machines have same timezone?
How fast are you generating WALs?
How are you shipping the WALs?
>
> The streaming replication is working fine... But if that goes down, I'll
> need the wal_files up to date to recover the database.
>
> How can I see what's going on? What would be the steps? any tips?
>
> Cheers
> Patrick.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick B | 2016-08-04 02:59:10 | Re: Question about wal files / pg_xlogs |
Previous Message | Patrick B | 2016-08-04 02:21:21 | Question about wal files / pg_xlogs |