pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
dump sizes changed...
3+ messages / 2 participants
[nested] [flat]

* dump sizes changed...
@ 2007-02-12 16:28  Lewis Kapell <lkapell@setonhome.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Lewis Kapell @ 2007-02-12 16:28 UTC (permalink / raw)
  To: pgsql-admin

We recently migrated to a new server after having had the old one 
running continously for over a year.  The first night that we did a 
backup, the file produced by pg_dumpall was noticably smaller than the 
one we got from the old server prior to the switchover (2.5 GB versus 
3.1 GB).

Is this something we should be alarmed about, or could this be the 
normal result of dumping and reloading a large database?

Thanks for any who can advise.
-- 

Thank you,

Lewis Kapell
Computer Operations
Seton Home Study School



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: dump sizes changed...
@ 2007-02-12 17:34  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Lewis Kapell <lkapell@setonhome.org>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2007-02-12 17:34 UTC (permalink / raw)
  To: Lewis Kapell <lkapell@setonhome.org>; +Cc: pgsql-admin

Lewis Kapell <lkapell@setonhome.org> writes:
> We recently migrated to a new server after having had the old one 
> running continously for over a year.  The first night that we did a 
> backup, the file produced by pg_dumpall was noticably smaller than the 
> one we got from the old server prior to the switchover (2.5 GB versus 
> 3.1 GB).

> Is this something we should be alarmed about,

It requires investigation at least.  Are these the same PG version, or
different ones?

We modified pg_dump awhile ago to be less verbose, but I think it was
only shortening the "comments" a bit; your result sounds too different
to be explained by that.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: dump sizes changed...
@ 2007-02-12 17:42  Lewis Kapell <lkapell@setonhome.org>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Lewis Kapell @ 2007-02-12 17:42 UTC (permalink / raw)
  To: pgsql-admin

Sorry, I should have given the versions.  The old server was running 
8.0.8, the new server is running 8.2.1.

Thank you,

Lewis Kapell
Computer Operations
Seton Home Study School


Tom Lane wrote:
> Lewis Kapell <lkapell@setonhome.org> writes:
>> We recently migrated to a new server after having had the old one 
>> running continously for over a year.  The first night that we did a 
>> backup, the file produced by pg_dumpall was noticably smaller than the 
>> one we got from the old server prior to the switchover (2.5 GB versus 
>> 3.1 GB).
> 
>> Is this something we should be alarmed about,
> 
> It requires investigation at least.  Are these the same PG version, or
> different ones?
> 
> We modified pg_dump awhile ago to be less verbose, but I think it was
> only shortening the "comments" a bit; your result sounds too different
> to be explained by that.
> 
> 			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-02-12 17:42 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-12 16:28 dump sizes changed... Lewis Kapell <lkapell@setonhome.org>
2007-02-12 17:34 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-02-12 17:42   ` Lewis Kapell <lkapell@setonhome.org>

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