Still the same :
checkpoint;
select pg_switch_wal();
select pg_switch_wal();
loading few tables and did a switch as well , still the same, not able to connect to standby database
psql: error: FATAL: the database system is starting up
On Tue, Jan 19, 2021 at 11:18 AM Paul Förster <paul.foerster@xxxxxxxxx> wrote:
Hi David,
> On 19. Jan, 2021, at 04:48, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
>
> 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’t seem very busy (though you also still need to do at least one write, empty wal files don’t 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
Best Regards,
Ankush Chawla
Ankush Chawla
