Обсуждение: Pg_dump

Поиск
Список
Период
Сортировка

Pg_dump

От
Rajesh Kumar
Дата:
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?

Re: Pg_dump

От
"David G. Johnston"
Дата:
On Thursday, December 7, 2023, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
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?

Non-compression of the dumped data?  Maybe give some help and show the commands you are using to check the size and perform the dump.

David J.
 

Re: Pg_dump

От
M Sarwar
Дата:
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.dba09@gmail.com>
Sent: Thursday, December 7, 2023 2:52 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.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?

Re: Pg_dump

От
jason cable
Дата:
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@outlook.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.dba09@gmail.com>
Sent: Thursday, December 7, 2023 2:52 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.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?

Re: Pg_dump

От
M Sarwar
Дата:
Jason,
Are you referring within the postgres database or are you referring to Big Data approach which needs new platforms?


From: jason cable <cablej2082@gmail.com>
Sent: Thursday, December 7, 2023 3:00 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.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@outlook.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.dba09@gmail.com>
Sent: Thursday, December 7, 2023 2:52 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.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?

Re: Pg_dump

От
Ron Johnson
Дата:
On Thu, Dec 7, 2023 at 2:52 PM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
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?

The exact command you ran.

Since you didn't show us the whole command, with options, we can't tell you.