Re: hot standby in Postgresql 12

Dominik Lehnen <dominik.lehnen@xxxxxxxxxxxx> · Tue, 19 Jan 2021 10:02:15 +0100

    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@xxxxxxxxx>
      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@xxxxxxxxxxxx

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)