Re: PITR based recovery failing due to difference in max_connections

2023-08-04 Thread Kalit Inani
Hi, Thanks for the quick response. Regarding your questions, *Why did you do that?* This is our requirement and we are restoring this on another instance(destination instance) where are the 'max_connection' value should be less than that of the source instance(150 in our case). On Fri, Aug 4, 2023

Re: PITR based recovery failing due to difference in max_connections

2023-08-03 Thread Ron
On 8/3/23 23:47, Kalit Inani wrote: Hi all, During PITR based recovery of a postgres instance, we are getting the following error - '2023-06-21 23:52:52.232 PDT [24244] FATAL:  hot standby is not possible because max_connections = 150 is a lower setting than on the master server (its value wa

PITR based recovery failing due to difference in max_connections

2023-08-03 Thread Kalit Inani
Hi all, During PITR based recovery of a postgres instance, we are getting the following error - '2023-06-21 23:52:52.232 PDT [24244] FATAL: hot standby is not possible because max_connections = 150 is a lower setting than on the master server (its value was 500)' Here are the steps we are followi