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@xxxxxxxxxx> 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
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
