Re: hot standby in Postgresql 12

From: Dominik Lehnen <dominik(dot)lehnen(at)gameduell(dot)de>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: hot standby in Postgresql 12
Date: 2021-01-19 09:02:15
Message-ID: a67376df-9688-c10c-18ca-d2f0e4a6f241@gameduell.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com
> <mailto:ankushchawla03(at)gmail(dot)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(dot)lehnen(at)gameduell(dot)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)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ganesh Korde 2021-01-19 09:09:42 Re: Re: PostgreSQL replication failover
Previous Message Jan Peters 2021-01-19 08:12:28 Aw: Re: PostgreSQL replication failover