Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1mu7-0002pK-MU for pgsql-admin@arkaria.postgresql.org; Tue, 19 Jan 2021 09:02:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1mu6-000392-Iy for pgsql-admin@arkaria.postgresql.org; Tue, 19 Jan 2021 09:02:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1mu6-00038v-Aw for pgsql-admin@lists.postgresql.org; Tue, 19 Jan 2021 09:02:22 +0000 Received: from bln4.gameduell.de ([213.95.169.180]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1mu1-0003f0-Eq for pgsql-admin@lists.postgresql.org; Tue, 19 Jan 2021 09:02:21 +0000 Received: from bln1.gameduell.de (phaeton.gd [10.1.1.148]) by bln4.gameduell.de (Postfix) with SMTP id 3DB0240EAC for ; Tue, 19 Jan 2021 10:02:16 +0100 (CET) Received: (qmail 20167 invoked from network); 19 Jan 2021 10:02:16 +0100 Received: from unknown (HELO mail-proxy.office.gameduell.de) (10.110.0.93) by phaeton.gd with SMTP; 19 Jan 2021 10:02:16 +0100 Received: from [192.168.178.44] (unknown [87.123.192.57]) by sputnik.gameduell.de (Postfix) with ESMTPSA id 229F5A04C7 for ; Tue, 19 Jan 2021 10:02:16 +0100 (CET) Subject: Re: hot standby in Postgresql 12 To: pgsql-admin@lists.postgresql.org References: <95BFBF96-8C8D-4691-BDE4-918F9F64A9CB@gmail.com> From: Dominik Lehnen Message-ID: Date: Tue, 19 Jan 2021 10:02:15 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------53045E08715D5963B34203E6" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------53045E08715D5963B34203E6 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 > 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) --------------53045E08715D5963B34203E6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

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