Re: hot standby in Postgresql 12

Поиск
Список
Период
Сортировка
От Ankush Chawla
Тема Re: hot standby in Postgresql 12
Дата
Msg-id CAOY8JhC+Dk3PgxQ1WfCMazFCYd+_E90Xak0Zx1eFG78MznaV5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: hot standby in Postgresql 12  (Ganesh Korde <ganeshakorde@gmail.com>)
Список pgsql-admin
Дерево обсуждения
this was steps followed at standby site

1. Create file standby.signal

2. Edit postgresql.conf  In Standby

hot_standby=on    (off by default will not allow queries to run only for high availability)

primary_conninfo = 'user=postgres password=<masterdbpassword> host=172.31.37.228 port=5333'

primary_slot_name = 'standby'

recovery_target_timeline = 'latest'

3. Save and start the Standby

Pg_Ctl start –D <>-l logfile


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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ankush Chawla
Дата:
Сообщение: Re: hot standby in Postgresql 12
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: hot standby in Postgresql 12