Re: Move base directory to different location

Поиск
Список
Период
Сортировка
От Holger Jakobs
Тема Re: Move base directory to different location
Дата
Msg-id 743cb100-60e5-8d44-5f16-122aadc78c4c@jakobs.com
обсуждение исходный текст
Ответ на Re: Move base directory to different location  (Paul Förster <paul.foerster@gmail.com>)
Список pgsql-admin
Hi Paul,

You are perfectly correct. I just answered very specific to the question.

Regards,

Holger

Am 26.11.20 um 15:05 schrieb Paul Förster:
> Hi Holger,
>
>> On 26. Nov, 2020, at 15:00, Holger Jakobs <holger@jakobs.com> wrote:
>>
>> It is no problem to move the base directory.
>>
>>     • stop the database server
>>     • move the base directory as a whole to some other location
>> mv /var/lib/pgsql/10/data/base /some/other/location
>>     • create a symbolic link pointing to the new location
>> cd /var/lib/pgsql/10/data
>> ln -s /some/other/location/base .
>>     • start the database server
>> BTW, an upgrade to a newer major version would be a good idea.
> why not just move the whole database and NOT create a symlink? Then just start the database in the new PGDATA? Of
courseyou'd need to reconfigure your PGDATA in this case but I consider it more clean than running a database cluster
ona symlink. 
>
> Cheers,
> Paul
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012



Вложения

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

Предыдущее
От: Pepe TD Vo
Дата:
Сообщение: Re: Move base directory to different location
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: Move base directory to different location