Re: General support on postgres replication

2023-11-23 Thread Laurenz Albe
On Thu, 2023-11-23 at 09:32 +, Vijaykumar Patil wrote: > LOG: entering standby mode > LOG: consistent recovery state reached at 1/27000100 > LOG: database system is ready to accept read-only connections > LOG: started streaming WAL from primary at 1/2800 on timeline 36 > LOG: recovery

RE: General support on postgres replication

2023-11-23 Thread Vijaykumar Patil
) [sender] Thanks Vijay Classification: Internal -Original Message- From: Laurenz Albe Sent: 23 November 2023 14:14 To: Vijaykumar Patil ; pgsql-general@lists.postgresql.org Subject: Re: General support on postgres replication This message was sent from outside of your organization

Re: General support on postgres replication

2023-11-23 Thread Laurenz Albe
On Wed, 2023-11-22 at 08:57 +, Vijaykumar Patil wrote: > I have created streaming replication with two nodes . >   > One is primary and 2nd one is standby but after doing any DML or DDL > operation on > primary Walreceiver process is terminated on standby and standby database is > opening in r

Re: General support on postgres replication

2023-11-22 Thread Ron Johnson
On Wed, Nov 22, 2023 at 11:17 AM Vijaykumar Patil < vijaykumar.pa...@maersk.com> wrote: > Hi Team, > > > > Need some support for below issue . > > > > I have created streaming replication with two nodes . > > > > One is primary and 2nd one is standby but after doing any DML or DDL > operation on p

General support on postgres replication

2023-11-22 Thread Vijaykumar Patil
Hi Team, Need some support for below issue . I have created streaming replication with two nodes . One is primary and 2nd one is standby but after doing any DML or DDL operation on primary Walreceiver process is terminated on standby and standby database is opening in read write mode. Below a