Re: Move base directory to different location - Mailing list pgsql-admin

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