pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lewis Kapell <lkapell@setonhome.org>
To: pgsql-admin@postgresql.org
Subject: dump sizes changed...
Date: Mon, 12 Feb 2007 11:28:50 -0500
Message-ID: <45D095C2.7080701@setonhome.org> (raw)

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



view thread (3+ messages)  latest in thread

Message-ID: <45D095C2.7080701@setonhome.org>
Permalink:  ../45D095C2.7080701@setonhome.org/
Also on:    postgresql.org/message-id/45D095C2.7080701@setonhome.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lkapell@setonhome.org
  Subject: Re: dump sizes changed...
  In-Reply-To: <45D095C2.7080701@setonhome.org>
  References: <45D095C2.7080701@setonhome.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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