Обсуждение: 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?
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 processWhat 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.
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
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?
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,SarwarFrom: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Sent: Thursday, December 7, 2023 2:52 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Pg_dumpI 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 processWhat coule be the issue?
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
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,SarwarFrom: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Sent: Thursday, December 7, 2023 2:52 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Pg_dumpI 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 processWhat coule be the issue?
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 processWhat 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.