Re: Unaccounted for disk use

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