Markus Schaber <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Instead of assuming anything, why don't you look in the tablespace >> directory and see what's there? A quick "ls -aR" would give more >> information than guessing.
> There's plenty of stuff there, 8.8 Gigabytes in total. The question is > how to determine if any of those files are still needed, and how to > migrate them so I can drop that tablespace. Match the subdirectory names against pg_database.oid --- any subdir that doesn't correspond to any live entry in pg_database is junk and can be flushed. Within a valid database's subdirectory, match the file names to that database's pg_class.relfilenode (not oid!) to see if any of them are live. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq