Re: Migrating a Database to a new tablespace

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Markus Schaber <schabi(at)logix-tt(dot)com> 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