Re: hot standby in Postgresql 12 - Mailing list pgsql-admin

From Dominik Lehnen
Subject Re: hot standby in Postgresql 12
Date
Msg-id a67376df-9688-c10c-18ca-d2f0e4a6f241@gameduell.de
Whole thread Raw
In response to Re: hot standby in Postgresql 12  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin

Hey,

maybe your needed wal files were already archived and are not available anymore?
In this case you have to set wal_keep_size to a proper value to keep the needed wal files on your primary.

Best,

Dom

On 19.01.21 07:26, David G. Johnston wrote:

On Monday, January 18, 2021, Ankush Chawla <ankushchawla03@gmail.com> wrote:
Still the same :

checkpoint;
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

And again, server log file?

David J.

-- 

Dominik Lehnen
Dev-Operations

t. +49 (0)30 288 768 855
e. dominik.lehnen@gameduell.de

GameDuell
Bringing people together to have a good time with games.

GameDuell GmbH, Taubenstraße 24-25, 10117 Berlin, Germany

We are looking for people to join our team!
http://inside.gameduell.com

HAUPTSITZ DER GESELLSCHAFT / HEADQUARTERS:
BERLIN, DEUTSCHLAND / GERMANY
GESCHÄFTSFÜHRER / MANAGING DIRECTORS:
KAI BOLIK & BORIS WASMUTH
HANDELSREGISTER / COMMERCIAL REGISTER:
AG BERLIN-CHARLOTTENBURG, HRB NR: 90891
UMSATZSTEUER-IDENTIFIKATIONSNUMMER / VAT ID: DE 813829498

(US Office: GameDuell Inc., 1156 Clement St., San Francisco, CA 94118, USA)

pgsql-admin by date:

Previous
From: Jan Peters
Date:
Subject: Aw: Re: PostgreSQL replication failover
Next
From: Ganesh Korde
Date:
Subject: Re: Re: PostgreSQL replication failover