Postgres Pro
Downloads
Home   >   mailing lists

Re: Migrating a Database to a new tablespace - Mailing list pgsql-sql

From Markus Schaber
Subject Re: Migrating a Database to a new tablespace
Date
Msg-id 444E208C.20901@logix-tt.com
Whole thread Raw
In response to Re: Migrating a Database to a new tablespace  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Migrating a Database to a new tablespace  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: SELECTing into usertype, how to do it?
Next
From: Tom Lane
Date:
Subject: Re: Migrating a Database to a new tablespace