Re: hot standby in Postgresql 12
| От | Ankush Chawla |
|---|---|
| Тема | Re: hot standby in Postgresql 12 |
| Дата | |
| Msg-id | CAOY8JhDEiqMkGxh7vpL5dxXvRcgshe0jXCUmzAw_Pad99FZP=A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: hot standby in Postgresql 12 (Ganesh Korde <ganeshakorde@gmail.com>) |
| Список | pgsql-admin |
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@gmail.com> 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@gmail.com> wrote:Preparing hot standby in PostgreSQL 12I 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 databaseDatabase 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
Ankush Chawla
В списке pgsql-admin по дате отправления: