Re: Pg_dump

From: M Sarwar <sarwarmd02(at)outlook(dot)com>
To: jason cable <cablej2082(at)gmail(dot)com>
Cc: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Pg_dump
Date: 2023-12-07 20:02:30
Message-ID: DM4PR19MB5978540B57358A17D5D1A59ED38BA@DM4PR19MB5978.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jason,
Are you referring within the postgres database or are you referring to Big Data approach which needs new platforms?

________________________________
From: jason cable <cablej2082(at)gmail(dot)com>
Sent: Thursday, December 7, 2023 3:00 PM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>; Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Pg_dump

do you feel the need to squeeze the big data through small hole for verification?

On Thu, Dec 7, 2023 at 11:59 AM M Sarwar <sarwarmd02(at)outlook(dot)com<mailto:sarwarmd02(at)outlook(dot)com>> wrote:
Luckily when I am taking a dump, database size is not growing. If the size grows, my dump will fail because it has no space left on my environment.
Thanks,
Sarwar

________________________________
From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com<mailto:rajeshkumar(dot)dba09(at)gmail(dot)com>>
Sent: Thursday, December 7, 2023 2:52 PM
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>>
Subject: Pg_dump

I could see the side of table inside db is 24 gb.

I was taking dump and it is growing over 30gb. Then I stopped dump process

What coule be the issue?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2023-12-07 21:31:54 Re: Pg_dump
Previous Message jason cable 2023-12-07 20:00:15 Re: Pg_dump