Re: Sequences not moved to new tablespace - Mailing list pgsql-general

From Guillaume Drolet
Subject Re: Sequences not moved to new tablespace
Date
Msg-id CAOkiyv4YJ9iFrSZCgmRHOBjRPjcpmWMCWyBxbmEia-RYz0BC4A@mail.gmail.com
Whole thread Raw
In response to Re: Sequences not moved to new tablespace  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Sequences not moved to new tablespace
List pgsql-general


2015-02-23 14:14 GMT-05:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 02/23/2015 10:08 AM, Guillaume Drolet wrote:
Hello,

I moved all my tables and indexes from one tablespace to pg_default using

ALTER TABLE ... SET TABLESPACE pg_default;
ALTER INDEX ... SET TABLESPACE pg_default;

Some 2500 files were moved to pg_default but 461 files remain in the
tablespace and so I cannot drop it.

When I query, for example:

SELECT oid, relname, relkind FROM pg_catalog.pg_class
WHERE oid IN (943602, 2650968, 2650971);

I see that most of these files are sequences. Why didn't they get moved
and how can I move them to pg_default (and all other remaining files) so
that I can drop the tablespace?

Well round file my previous suggestion. Just tried it and it did not work.


Thanks Adrian.
So, anybody else have some piece of advice on this?

Thanks!



--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Stanislav Antic
Date:
Subject: pg_basebackup fails on inactive slave
Next
From: Guillaume Drolet
Date:
Subject: Re: Sequences not moved to new tablespace