PostgreSQL V13 Replication Issue

2021-06-16 Thread Haseeb Khan
Hello Everyone, Apologies in advance I don't know where to get knowledge regarding this issue that's why I posted here, Highly appreciated if someone could help on this regard We have installed and configured PostgreSQL V13 Master- Slave streaming replication on Windows server 2016 but replicati

Re: Master - Slave Replication Window Server

2021-06-15 Thread Haseeb Khan
t; > On 15/06/21, Haseeb Khan (khanhasee...@gmail.com) wrote: >> I have confusion below, Should we create an archive path on the standby >> server and then set it to recovery.conf file ? >> >> restore_command = 'cp /path/to/archive/%f %p' > > Hi H

Re: Master - Slave Replication Window Server

2021-06-14 Thread Haseeb Khan
Hello Rory, Hope you're doing well ! I have confusion below, Should we create an archive path on the standby server and then set it to recovery.conf file ? restore_command = 'cp /path/to/archive/%f %p' *BR,* Haseeb Ahmad On Tue, Jun 15, 2021 at 10:42 AM Haseeb Khan wro

Re: Master - Slave Replication Window Server

2021-06-14 Thread Haseeb Khan
Thankyou Rory ! Br, Haseeb Ahmad > On 15-Jun-2021, at 12:42 AM, Rory Campbell-Lange > wrote: > > On 15/06/21, Haseeb Khan (khanhasee...@gmail.com) wrote: >> Does anyone have complete documentation to configure PostgreSQL V13 Master >> and Slave on Windows Server and

Master - Slave Replication Window Server

2021-06-14 Thread Haseeb Khan
Hello Everyone ! I trust that you guys are keep doing very Well ! Does anyone have complete documentation to configure PostgreSQL V13 Master and Slave on Windows Server and also how to test Manual Failover ? Would highly appreciated, if someone could help in this regard. Br, Haseeb Ahmad

Re: Page File Size Reached Critical Threshold PostgreSQL V13

2021-06-09 Thread Haseeb Khan
Hi Justin, You mean, So should I request for to increase the System Ram from 32 Gb to 64 Gb and keep the same parameter setting.Is it ? Br, Haseeb Ahmad > > On 10-Jun-2021, at 9:28 AM, Justin Pryzby wrote: > > On Thu, Jun 10, 2021 at 05:45:45AM +0500, Haseeb Khan wrote

Page File Size Reached Critical Threshold PostgreSQL V13

2021-06-09 Thread Haseeb Khan
Hello Everyone, I trust that everyone is Keep doing very Well ! We have installed PostgreSQL V13 on window’s server 2016, where we kept the Ram of the Server is 32 GB and disk size is 270 GB.Later we faced some performance issues regarding the database, after deep dive into it we came up and in