OK, great. Thank. And when I recreate it, should I do so from a template, or just CREATE DATABASE postgres ? On 2011-10-26, at 4:10 PM, Tom Lane wrote: > =?iso-8859-1?Q?Ren=E9_Fournier?= <m5@xxxxxxxxxxxxxxxx> writes: >> I accidentally imported lots of data into the postgres database via something like: >> psql -U postgres -q -f super_massive_database_dump.sql > >> Now, although I've manually dropped all the tables -- and \d+ shows >> nothing -- there are still various views, functions, etc that must >> account for a lot of disk space. From \l+, I see that postgres still >> occupies 65GB. > > [ raised eyebrow ... ] It's pretty hard to conceive of system catalogs > occupying 65GB. You might want to look into where that number is coming > from. (Large objects maybe?) > >> So my question is, what's the easiest way to reclaim >> that space? Can I drop postgres and just recreate it? > > Yeah, if you want. > > regards, tom lane > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
