Skip site navigation (1) Skip section navigation (2)

Re: DB Dump Size

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: DB Dump Size
Date: 2008-08-18 14:57:42
Message-ID: 195974.83929.qm@web25806.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
> I am also curious as to why an SQL dump from the production
> server would
> come out to 2.8G but a dump of an exact replica on a test
> box would come
> out to 3.0G. What determines the size and makeup of an SQL
> dump?


Why not repeat the dump without any compression then compare them with a file comparison tool?



Send instant messages to your online friends http://uk.messenger.yahoo.com 

In response to

pgsql-admin by date

Next:From: Robert TreatDate: 2008-08-18 15:48:14
Subject: Re: Best practice running a shared DB hosting server
Previous:From: steveDate: 2008-08-18 01:35:00
Subject: Re: DB Dump Size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group