Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.20.0.2.21\))
Subject: Re: Move base directory to different location
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: <31b748c7-d728-9d8d-fb49-b6b935b8295b@jakobs.com>
Date: Thu, 26 Nov 2020 15:05:26 +0100
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <99166572-4225-4508-ADA6-F002339C2228@gmail.com>
References: 
 <CALhHtcANxVwbRYZYyBtZ4G4jJtm+b4vJgs5vp=8twS-9YWC41Q@mail.gmail.com>
 <31b748c7-d728-9d8d-fb49-b6b935b8295b@jakobs.com>
To: Holger Jakobs <holger@jakobs.com>
Precedence: bulk

Hi Holger,

> On 26. Nov, 2020, at 15:00, Holger Jakobs <holger@jakobs.com> wrote:
>=20
> It is no problem to move the base directory.
>=20
> 	=E2=80=A2 stop the database server
> 	=E2=80=A2 move the base directory as a whole to some other =
location
> mv /var/lib/pgsql/10/data/base /some/other/location
> 	=E2=80=A2 create a symbolic link pointing to the new location
> cd /var/lib/pgsql/10/data
> ln -s /some/other/location/base .
> 	=E2=80=A2 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=