Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.40.0.2.32\))
Subject: Re: hot standby in Postgresql 12
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: 
 <CAKFQuway06_MQp3iG2dpOfi+bJ-c7g1hZC1bBXHroraM9Kz0ww@mail.gmail.com>
Date: Tue, 19 Jan 2021 06:48:17 +0100
Cc: Ankush Chawla <ankushchawla03@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <95BFBF96-8C8D-4691-BDE4-918F9F64A9CB@gmail.com>
References: 
 <CAOY8JhBPpZ8JvZ8PGUzAbpz17Ra4yJ4w1s=oja0qzsY3sHdSOg@mail.gmail.com>
 <CAKFQuwbMPfZAcS6tgy3LR9ZVXQMewFkPGfUr4M5nY-4LfChhmg@mail.gmail.com>
 <CAOY8JhA114Ra77p5b5q7xiU6CgxksbX+wzQRcoT_sRQ1O20Kwg@mail.gmail.com>
 <CAKFQuway06_MQp3iG2dpOfi+bJ-c7g1hZC1bBXHroraM9Kz0ww@mail.gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Precedence: bulk

Hi David,

> On 19. Jan, 2021, at 04:48, David G. Johnston =
<david.g.johnston@gmail.com> wrote:
>=20
> And now the standby is waiting for the next wal file to be archived by =
the primary.  You should probably set archive_timeout to a non-zero =
value since the primary doesn=E2=80=99t seem very busy (though you also =
still need to do at least one write, empty wal files don=E2=80=99t get =
rotated out and archived.)

you should be able to get around your problem by doing the following on =
the primary database:

checkpoint;
select pg_switch_wal();

The pg_switch_wal() alone will not trigger WAL file generation if no =
transaction has been going on. That's why I recommend forcing a =
checkpoint before that (same with Oracle by the way).

As soon as a WAL is generated, it should get shipped to the standby =
database. Then it should open.

Cheers,
Paul=