From: | Holger Jakobs <holger(at)jakobs(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Move base directory to different location |
Date: | 2020-11-26 14:25:41 |
Message-ID: | 743cb100-60e5-8d44-5f16-122aadc78c4c@jakobs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)jakobs(dot)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 course you'd need to reconfigure your PGDATA in this case but I consider it more clean than running a database cluster on a symlink.
>
> Cheers,
> Paul
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2020-11-26 14:27:10 | Re: Move base directory to different location |
Previous Message | Pepe TD Vo | 2020-11-26 14:06:19 | Re: Move base directory to different location |