Re: PG 10 streaming replication pg_wal question

From: bricklen <bricklen(at)gmail(dot)com>
To: ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PG 10 streaming replication pg_wal question
Date: 2017-11-30 18:46:00
Message-ID: CAGrpgQ8LC4O04QBT9N5uj3bf=49SQn5XNN3J=ue20kR_bS-0zw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Nov 30, 2017 at 10:19 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> ghiureai wrote:
> > can I run a checkpoint manually in master host than ?
>
> Yes, but that will only remove WAL files if there has
> been enough activity to cause one or more WAL switches.
>
> You just have to wait.
>

​Note that you can shorten that waiting time by executing, as a superuser:
checkpoint;
select pg_switch_wal();​

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message koffi BADOH 2017-11-30 20:17:24 Newbie looking for good tutorial to install PL/java for postgres 9.6
Previous Message Laurenz Albe 2017-11-30 18:19:43 Re: PG 10 streaming replication pg_wal question