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(at)gmail(dot)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(at)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
>
>