Re: moving tables

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: moving tables
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C20808D4EB@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Re: moving tables  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh Berkus wrote:
> On 6/20/12 3:27 PM, Midge Brown wrote:
>> I need to move a postgres 9.0 database -- with tables, indexes, and wals associated with 16
>> tablespaces on 12 logical drives -- to an existing raid 10 drive in another volume on the same server.
>> Once I get the data off the initial 12 drives they will be reconfigured, at which point I'll need to
>> move everything from the 2nd volume to the aforementioned 12 logical drives on the first volume. This
>> is being done both to free up the 2nd volume and to better utilize raid 10.
>>
>> I checked around and found a way to create sql statements to alter the public tablespaces and
>> indexes, but I haven't found anything that provides information about moving the numerous associated
>> config files, log files, etc.
>>
>> ANY comments, suggestions, or direction to existing documentation would be greatly appreciated.

> 1. back everything up.
> 
> 2. create a bunch of directories on the RAID10 to match the existing
> tablespaces (they won't be mounts, but Postgres doesn't care about that).
> 
> 3. shut down postgres
> 
> 4. copy all your files to the new directories
> 
> 5. change your mount points which were in use by the old tablespaces to
> symlinks which point at the new diretories
> 
> 6. start postgres back up from the new location

Shouldn't you also

7. UPDATE spclocation in pg_tablespace ?

Yours,
Laurenz Albe

В списке pgsql-performance по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: index-only scan is missing the INCLUDE feature
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Why is a hash join being used?