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: PostgreSQL V13 Replication Issue

2021-06-16 Thread Dean Gibson (DB Administrator)
I'm no expert, but it looks like you are reading v9.6 documentation for a v13 installation. On 2021-06-16 09:25, Haseeb Khan wrote: ... hot_standby = on ... *recovery.conf file* standby_mode = 'on'

Estimating wal_keep_size

2021-06-16 Thread Dean Gibson (DB Administrator)
Is this reasonable thinking? I'd think that one would want a *wal_keep_size* to cover the pending updates while the standby server might be unavailable, however long one might anticipate that would be. In my case, I get a complete replacement (in the form of "|"- delimited ASCII files) of on

Re: Estimating wal_keep_size

2021-06-16 Thread Julien Rouhaud
On Wed, Jun 16, 2021 at 05:36:24PM -0700, Dean Gibson (DB Administrator) wrote: > Is this reasonable thinking? > > I'd think that one would want a *wal_keep_size* to cover the pending updates > while the standby server might be unavailable, however long one might > anticipate that would be. It's

Re: PostgreSQL V13 Replication Issue

2021-06-16 Thread Michael Paquier
On Wed, Jun 16, 2021 at 09:25:37PM +0500, Haseeb Khan wrote: > Would be highly appreciated, if someone could tell me what exactly the > issue is or what I am missing in the configuration on both the servers > (master- slave).Why replication is not working? Your issue is partially here, as recovery