pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestions on pg_dump
2+ messages / 1 participants
[nested] [flat]
* Questions on pg_dump
@ 2008-07-18 17:05 Chris Hoover <revoohc@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Chris Hoover @ 2008-07-18 17:05 UTC (permalink / raw)
To: pgsql-admin
We are doing some additional testing of our backup strategy with the goal of
moving from the text dump to the custom format and have some questions about
pg_dump -Fc.
Question 1. Why would the custom format be larger? pg_dump -Fc -Z 0 this
morning was 88GB while the normal pg_dump last night was 82GB. We have not
had that much growth in the few intervening hours. We were expecting the
-Fc to be at the most the same size of the text dump, and really expecting
the -Fc to be smaller. Any explanations? (We are doing timing with various
levels of compression and with the use of external compression to see what
gives us the best compression/time, so that is why the -Z 0 test.)
Question 2. With the -Fc, how can we verify a successful backup? With the
normal pg_dump, we are examining the end of the file looking for:
--
-- PostgreSQL database dump complete
--
Is there any sort of token like that with the -Fc that can be used to verify
a successful backup?
Thanks,
Chris
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Questions on pg_dump
@ 2008-07-18 20:58 Chris Hoover <revoohc@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Chris Hoover @ 2008-07-18 20:58 UTC (permalink / raw)
To: Scott Mead <scottiebo@gmail.com>; +Cc: pgsql-admin
We understand that. The question is why is an uncompressed Fc format so
much larger than a straight dump? Is the so bad it takes almost 5% extra
space?
On Fri, Jul 18, 2008 at 2:36 PM, Scott Mead <scottiebo@gmail.com> wrote:
> Chris,
>
> Sorry I'm not responding to the list, I am not allowed to post from
> my corporate account, and this account is not subscribed to the admin
> list.
>
> -Z 0 means no compression. You'll want to stick with the default
> or -Z 9 for highest compression.
>
> Hope this helps!
>
> --Scott
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-18 20:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-18 17:05 Questions on pg_dump Chris Hoover <revoohc@gmail.com>
2008-07-18 20:58 Re: Questions on pg_dump Chris Hoover <revoohc@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox