From: | Ankush Chawla <ankushchawla03(at)gmail(dot)com> |
---|---|
To: | Ganesh Korde <ganeshakorde(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: hot standby in Postgresql 12 |
Date: | 2021-01-19 09:20:40 |
Message-ID: | CAOY8JhDEiqMkGxh7vpL5dxXvRcgshe0jXCUmzAw_Pad99FZP=A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)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(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
>>
>>
--
Best Regards,
Ankush Chawla
From | Date | Subject | |
---|---|---|---|
Next Message | Ankush Chawla | 2021-01-19 09:32:12 | Re: hot standby in Postgresql 12 |
Previous Message | Ganesh Korde | 2021-01-19 09:19:37 | Re: hot standby in Postgresql 12 |