From: | Guillaume Drolet <droletguillaume(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Sequences not moved to new tablespace |
Date: | 2015-02-24 15:47:05 |
Message-ID: | CAOkiyv6d9piE2U7MpAgn7zfkgWeGFU8HZDjrfkDAnONT8_K-Hw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2015-02-24 10:18 GMT-05:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> On 02/24/2015 07:10 AM, Guillaume Drolet wrote:
>
>>
>>
>>
>
>>
>> So how did all this stuff get into the non-default tablespace in the
>> first place?
>>
>>
>> Stuff got there using the ALTER TABLE.../ALTER INDEX... SQL files
>> mentionned in my previous post.
>>
>>
>> The answer would seem to be just reverse whatever you did in answer
>> to the question above.
>>
>>
>> That makes sense. I will give it a try. Thanks.
>>
>
> Alright, now I am thoroughly confused:) I thought this is how you to this
> point, using the above commands to move from the non-default tablespace
> back to the default tablespace:
>
> "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;"
>
> And that the issue was that sequences where not moved back.
>
That was the issue described in my original post, i.e. that tables and
indexes were moved to pg_default but that sequences and tables from
pg_catalog did not follow.
I'm now trying to figure how to really do it!
>
>
>>
>>
>>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Drolet | 2015-02-24 15:59:55 | Re: Sequences not moved to new tablespace |
Previous Message | Adrian Klaver | 2015-02-24 15:40:47 | Re: Sequences not moved to new tablespace |