Re: Database size different on Primary and Standby?

2023-01-18 Thread Ron
On 1/18/23 17:09, Hilbert, Karin wrote: I manage some PostgreSQL clusters on Linux.  We have a Primary & two Standby servers & for Production, there is also a DR server.  We use repmgr for our HA solution & the Standbys are cloned from the Primary using the *repmgr standby clone* command. My

Re: Database size different on Primary and Standby?

2023-01-18 Thread Tom Lane
Erik Wienhold writes: > On 19/01/2023 01:23 CET Ian Lawrence Barwick wrote: >> This is incorrect; with streaming replication all changes applied on the >> primary >> are applied on the standby. > Thanks. I was thinking about logical replication. It's not entirely clear whether the OP is talkin

Re: Database size different on Primary and Standby?

2023-01-18 Thread Erik Wienhold
> On 19/01/2023 01:23 CET Ian Lawrence Barwick wrote: > > 2023年1月19日(木) 8:50 Erik Wienhold : > > > > > On 19/01/2023 00:09 CET Hilbert, Karin wrote: > > > > > > I manage some PostgreSQL clusters on Linux. We have a Primary & two > > > Standby > > > servers & for Production, there is also a DR se

Re: Database size different on Primary and Standby?

2023-01-18 Thread Ian Lawrence Barwick
2023年1月19日(木) 8:50 Erik Wienhold : > > > On 19/01/2023 00:09 CET Hilbert, Karin wrote: > > > > I manage some PostgreSQL clusters on Linux. We have a Primary & two Standby > > servers & for Production, there is also a DR server. We use repmgr for our > > HA > > solution & the Standbys are cloned f

Re: Database size different on Primary and Standby?

2023-01-18 Thread Erik Wienhold
> On 19/01/2023 00:09 CET Hilbert, Karin wrote: > > I manage some PostgreSQL clusters on Linux. We have a Primary & two Standby > servers & for Production, there is also a DR server. We use repmgr for our HA > solution & the Standbys are cloned from the Primary using the repmgr standby > clone com

Database size different on Primary and Standby?

2023-01-18 Thread Hilbert, Karin
I manage some PostgreSQL clusters on Linux. We have a Primary & two Standby servers & for Production, there is also a DR server. We use repmgr for our HA solution & the Standbys are cloned from the Primary using the repmgr standby clone command. My manager asked for a report of all the user d