Re: Migrating a Database to a new tablespace

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Migrating a Database to a new tablespace
Date: 2006-04-25 15:19:39
Message-ID: 19435.1145978379@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Markus Schaber <schabi(at)logix-tt(dot)com> writes:
> So when pgadmin3 displays no dependencies, can I assume it is safe to
> empty the tablespace directory manually, and then drop the tablespace?

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.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-04-25 16:50:33 Re: Migrating a Database to a new tablespace
Previous Message Markus Schaber 2006-04-25 13:13:48 Re: Migrating a Database to a new tablespace