pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Dominik Lehnen <dominik.lehnen@gameduell.de>
To: pgsql-admin@lists.postgresql.org
Subject: Re: hot standby in Postgresql 12
Date: Tue, 19 Jan 2021 10:02:15 +0100
Message-ID: <a67376df-9688-c10c-18ca-d2f0e4a6f241@gameduell.de> (raw)
In-Reply-To: <CAKFQuwZL_x7oqEtB=FPQLExezkZm8t5_qDdbN+QkOpz__kg1=A@mail.gmail.com>
References: <CAOY8JhBPpZ8JvZ8PGUzAbpz17Ra4yJ4w1s=oja0qzsY3sHdSOg@mail.gmail.com>
	<CAKFQuwbMPfZAcS6tgy3LR9ZVXQMewFkPGfUr4M5nY-4LfChhmg@mail.gmail.com>
	<CAOY8JhA114Ra77p5b5q7xiU6CgxksbX+wzQRcoT_sRQ1O20Kwg@mail.gmail.com>
	<CAKFQuway06_MQp3iG2dpOfi+bJ-c7g1hZC1bBXHroraM9Kz0ww@mail.gmail.com>
	<95BFBF96-8C8D-4691-BDE4-918F9F64A9CB@gmail.com>
	<CAOY8JhA6Ki2i_CvQLgu94t=NxcMb4k6N_MiS3nM1j=_qaGH2MA@mail.gmail.com>
	<CAKFQuwZL_x7oqEtB=FPQLExezkZm8t5_qDdbN+QkOpz__kg1=A@mail.gmail.com>

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

view thread (19+ messages)  latest in thread

Message-ID: <a67376df-9688-c10c-18ca-d2f0e4a6f241@gameduell.de>
Permalink:  ../a67376df-9688-c10c-18ca-d2f0e4a6f241@gameduell.de/
Also on:    postgresql.org/message-id/a67376df-9688-c10c-18ca-d2f0e4a6f241@gameduell.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: dominik.lehnen@gameduell.de, pgsql-admin@lists.postgresql.org
  Subject: Re: hot standby in Postgresql 12
  In-Reply-To: <a67376df-9688-c10c-18ca-d2f0e4a6f241@gameduell.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox