did you do vacuum full? Or just a vacuum?
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Chris Cameron
Sent: Tuesday, May 20, 2003 7:51 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Unaccounted for disk use
I was running the pgMigration plugin for PgAdminII and half way along,
it failed.
Thing is, there's about 142 megs of space being used up by my data/
directory that really doesn't show up as tables anywhere.
The database that was receiving all this information is empty. I've done
what little I could think of which is turn Postgres off and on again,
and vaccumm the DB(s). The space is still being used.
How is it I can get rid of this?
Thanks,
Chris
--
Chris Cameron
UpNIX Internet Administrator
ardvark.upnix.net
bitbucket.upnix.net
--
http://www.upnix.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster