Re: hot standby in Postgresql 12 - Mailing list pgsql-admin

From David G. Johnston
Subject Re: hot standby in Postgresql 12
Date
Msg-id CAKFQuwbMPfZAcS6tgy3LR9ZVXQMewFkPGfUr4M5nY-4LfChhmg@mail.gmail.com
Whole thread Raw
In response to hot standby in Postgresql 12  (Ankush Chawla <ankushchawla03@gmail.com>)
Responses Re: hot standby in Postgresql 12
List pgsql-admin
On Monday, January 18, 2021, 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


The database is starting up, this is expected.  You need to consult the server logs for relevant information pertaining to the startup/restore process.

David J.

pgsql-admin by date:

Previous
From: Ankush Chawla
Date:
Subject: hot standby in Postgresql 12
Next
From: Ankush Chawla
Date:
Subject: Re: hot standby in Postgresql 12