Re: hot standby in Postgresql 12

[Ankush Chawla <ankushchawla03@xxxxxxxxx>]

it is there only in postgresql.conf .

I am usign postgresql 12 so not using recovery.conf but using standby.signal

On Tue, Jan 19, 2021 at 2:49 PM Ganesh Korde <ganeshakorde@xxxxxxxxx> wrote:

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

--

Best Regards,
Ankush Chawla