Re: Reg: Size difference

2024-09-14 Thread Adrian Klaver
On 9/14/24 11:10, Vinay Oli wrote: Hi  I've checked the database size by meta command \l+ and even I checked from file system level du -sh 49181 folder. 49181 is the db oid. Minimal information is not going to solve this issue. Provide the exact output of commands from: 1) The Primary data

Re: Reg: Size difference

2024-09-14 Thread Vinay Oli
Hi , I've verified there's no crap sitting. I've checked the database size by meta command \l+ and even I checked from file system level du -sh 49181 folder. 49181 is the db oid. Thanks, Vinay kumar On Sat, Sep 14, 2024, 11:00 PM Laurenz Albe wrote: > On Sat, 2024-09-14 at 22:49 +0530, Vina

Re: Reg: Size difference

2024-09-14 Thread Vinay Oli
Hi I've checked the database size by meta command \l+ and even I checked from file system level du -sh 49181 folder. 49181 is the db oid. Pgwal directory is same 40gb at primary and standby servers. All the directories are of same size, 49181 folder (oid) is only having different size. Tha

Re: Reg: Size difference

2024-09-14 Thread Ron Johnson
On Sat, Sep 14, 2024 at 1:19 PM Vinay Oli wrote: > Hi Team > > I have been using PostgreSQL for the past 6 years. PostgreSQL has > significantly impacted my life, providing me with great opportunities for > knowledge and self-development. > > I'm currently facing a strange issue with PostgreSQL 1

Re: Reg: Size difference

2024-09-14 Thread Laurenz Albe
On Sat, 2024-09-14 at 22:49 +0530, Vinay Oli wrote: > I'm currently facing a strange issue with PostgreSQL 15.0. I have a > primary-standby setup that is in sync, with a replication slot in place. > There are 18 databases, and one of the databases on the primary side > is 104 GB, while the same dat

Re: Reg: Size difference

2024-09-14 Thread Adrian Klaver
On 9/14/24 10:19, Vinay Oli wrote: Hi Team I have been using PostgreSQL for the past 6 years. PostgreSQL has significantly impacted my life, providing me with great opportunities for knowledge and self-development. I'm currently facing a strange issue with PostgreSQL 15.0. I have a primary-

Re: Reg: Size difference

2024-09-13 Thread Karsten Hilbert
Am Fri, Sep 13, 2024 at 05:39:22PM +0530 schrieb Vinay Oli: > I'm currently facing a strange issue with PostgreSQL 15.0. I have a > primary-standby setup that is in sync, with a replication slot in place. > There are 18 databases, and one of the databases on the primary side is 104 > GB, while the