From: Markus Schaber <schabi@logix-tt.com>
To: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Migrating a Database to a new tablespace
Date: Mon, 24 Apr 2006 13:34:33 +0200
Message-ID: <444CB7C9.8060307@logix-tt.com> (raw)
In-Reply-To: <444CA971.3000505@logix-tt.com>
References: <4444D607.1000309@logix-tt.com>
<444CA2F5.4030705@logix-tt.com>
<444CA971.3000505@logix-tt.com>
Hello,
I now pulled the plug, migrated all databases via "create database ...
tempate olddatabase tablespace newts" to new tablespaces, one for each
database, and dropped all old databases that contained references to the
tablespace. Pgadmin3 also shows that the tablespace is not referenced by
anything.
But I cannot drop it, I get the following message:
postgres=# drop TABLESPACE foo;
ERROR: tablespace "foo" is not empty
It seems that the whole tablespace thing is not yet 100% waterproof,
good that this did happen on a developer machine, and not on a
production machine.
Thanks for your patience,
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: schabi@logix-tt.com
Subject: Re: Migrating a Database to a new tablespace
In-Reply-To: <444CB7C9.8060307@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox