pg_dump and diffrent sizes

From: Maciej Piekielniak <piechcio(at)isb(dot)com(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_dump and diffrent sizes
Date: 2006-03-03 20:10:26
Message-ID: 6810493901.20060303211026@isb.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello pgsql-sql,

I dump db with pg_dump v.8.1.3 on database postgresql server 7.4.7.
Data directory with my db on pg 7.4.7 had 1,8GB and
file with dump had 2,7GB.
Database have blob fields.

When I restore db on pg 8.1 - data directory have only 1GB, why?

--
Best regards,
Maciej mailto:piechcio(at)isb(dot)com(dot)pl

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2006-03-03 20:15:31 Re: pg_dump and diffrent sizes
Previous Message Andrew Sullivan 2006-03-03 19:40:39 Re: Sequential scan where Index scan expected (update)