MIME-Version: 1.0
References: 
 <CAOY8JhBPpZ8JvZ8PGUzAbpz17Ra4yJ4w1s=oja0qzsY3sHdSOg@mail.gmail.com>
In-Reply-To: 
 <CAOY8JhBPpZ8JvZ8PGUzAbpz17Ra4yJ4w1s=oja0qzsY3sHdSOg@mail.gmail.com>
From: Ganesh Korde <ganeshakorde@gmail.com>
Date: Tue, 19 Jan 2021 14:49:37 +0530
Message-ID: 
 <CAPNyb0Wi77y4Z1Fb8OM5w8S7oCo2P8aLD1_PhP2tRdvjhePE6Q@mail.gmail.com>
Subject: Re: hot standby in Postgresql 12
To: Ankush Chawla <ankushchawla03@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001ea5dc05b93d5722"
Precedence: bulk

--0000000000001ea5dc05b93d5722
Content-Type: text/plain; charset="UTF-8"

Looks like you have mentioned "hot_standby= on" on both places i.e
recovery.conf and postgresql.conf. keep it at only one place and check.

On Tue, 19 Jan 2021, 8:51 am Ankush Chawla, <ankushchawla03@gmail.com>
wrote:

> Preparing hot standby in PostgreSQL 12
>
> I have created a standby.signal file and added the parameter
> hot_standby='on' in postgresql.conf file but i am still not able to query
> the standby database
> Database is not getting open for reading.
>
> postgres@ip-172-31-31-150:/u01/db10/pg_wal> psql -p 5490
> psql: error: FATAL:  the database system is starting up
>
> --
> Best Regards,
> Ankush Chawla
>
>

--0000000000001ea5dc05b93d5722
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Looks like you have mentioned &quot;hot_standby=3D on&quo=
t; on both places i.e=C2=A0 recovery.conf and postgresql.conf. keep it at o=
nly one place and check.</div><br><div class=3D"gmail_quote"><div dir=3D"lt=
r" class=3D"gmail_attr">On Tue, 19 Jan 2021, 8:51 am Ankush Chawla, &lt;<a =
href=3D"mailto:ankushchawla03@gmail.com">ankushchawla03@gmail.com</a>&gt; w=
rote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex=
;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>Prepari=
ng hot standby in PostgreSQL 12</div><div><br></div><div>I have created a s=
tandby.signal file and added the parameter hot_standby=3D&#39;on&#39; in po=
stgresql.conf file but i am still not able to query the standby database=C2=
=A0</div><div>Database=C2=A0is not getting open for reading.</div><div><br>=
</div><div>postgres@ip-172-31-31-150:/u01/db10/pg_wal&gt; psql -p 5490<br>p=
sql: error: FATAL: =C2=A0the database system is starting up</div><div><br><=
/div>-- <br><div dir=3D"ltr" data-smartmail=3D"gmail_signature"><div dir=3D=
"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr">Best Regards,<br>Ankush C=
hawla<br><br></div></div></div></div></div></div></div>
</blockquote></div>

--0000000000001ea5dc05b93d5722--