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)
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 |