Re: Moving database cluster

Поиск
Список
Период
Сортировка
От Fernando Hevia
Тема Re: Moving database cluster
Дата
Msg-id EA81CEE83870476C91220DD395C96A9A@iptel.com.ar
обсуждение исходный текст
Ответ на Re: Moving database cluster  ("Joshua J. Kugler" <joshua@eeinternet.com>)
Ответы Re: Moving database cluster
Список pgsql-general

> -----Mensaje original-----
> De:
>
> On Thursday 14 January 2010, Fernando Hevia elucidated thus:
> > An Ubuntu install creates a postgres cluster automatically on
> > /var/lib/postgresql/8.4/main Whats the best procedure for
> moving this
> > cluster to an other location? Should I just rerun initdb?
> What happens
> > then with the default cluster or how could I delete it?
>
> The easiest way is to shut down Pg, move the 'main' directory
> somewhere else, and then point a symlink to the new location.
>

Thanks for your reply.
I had considered this first but then I wasn't sure if there would be any
performance penalty.
The current main directory sits on a 'slow' RAID 1 volume while the new one
will sit on a 'fast' 12 disk RAID 10 volume.
I guess the symlink shouldn't be troublesome but I don't know if some PG
process will continually be reading this link encumbering somehow the RAID 1
disks.

Regards,
Fernando.


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

Предыдущее
От: "Fernando Hevia"
Дата:
Сообщение: Re: Moving database cluster
Следующее
От: "Joshua J. Kugler"
Дата:
Сообщение: Re: Moving database cluster