What exactly permissions are required to vacuum every table including
system catalogs ?
Thanks , -alex
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, September 06, 2006 9:41 AM
To: Sriram Dandapani
Cc: pgsql-admin@postgresql.org
It might happen because of the type of
data you have ( binary images). The compression for binary files is notorious horrible
since there is a small chance of occurrence of same chars
In other words it is possible since during
compression there are additional chars added for checksums and
You could archive the data as you perform the
dump
pg_dump | bzip2
> filename.bz2
bzip2 offers an excellent compression and you
could end up with an archive with less than 10GB
Later you can reload that into another db on
a different server
-Original
Message-
From:
