Re: Migrating a Database to a new tablespace

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Migrating a Database to a new tablespace
Date: 2006-04-25 13:13:48
Message-ID: 444E208C.20901@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, Jim,

Jim C. Nasby wrote:
> That means that the tablespace directory isn't empty.

This might be some artifacts from backend kills / crashes, partially
during COPY and CREATE DATABASE operations. (It's a developer machine
after all).

So when pgadmin3 displays no dependencies, can I assume it is safe to
empty the tablespace directory manually, and then drop the tablespace?

Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-04-25 15:19:39 Re: Migrating a Database to a new tablespace
Previous Message A. Kretschmer 2006-04-25 12:42:18 Re: SELECTing into usertype, how to do it?