Subject: Re: Move base directory to different location
To: pgsql-admin@lists.postgresql.org
References: 
 <CALhHtcANxVwbRYZYyBtZ4G4jJtm+b4vJgs5vp=8twS-9YWC41Q@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
Message-ID: <31b748c7-d728-9d8d-fb49-b6b935b8295b@jakobs.com>
Date: Thu, 26 Nov 2020 15:00:28 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.5.0
MIME-Version: 1.0
In-Reply-To: 
 <CALhHtcANxVwbRYZYyBtZ4G4jJtm+b4vJgs5vp=8twS-9YWC41Q@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="kz6UKAHL6BbMHzqqJ0iVRwlW42s7UbPzO"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--kz6UKAHL6BbMHzqqJ0iVRwlW42s7UbPzO
Content-Type: multipart/mixed; boundary="Zjb4PajA5TJ0Nd9KqzjGhUBb4jk3U2w4s";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <31b748c7-d728-9d8d-fb49-b6b935b8295b@jakobs.com>
Subject: Re: Move base directory to different location
References: <CALhHtcANxVwbRYZYyBtZ4G4jJtm+b4vJgs5vp=8twS-9YWC41Q@mail.gmail.com>
In-Reply-To: <CALhHtcANxVwbRYZYyBtZ4G4jJtm+b4vJgs5vp=8twS-9YWC41Q@mail.gmail.com>

--Zjb4PajA5TJ0Nd9KqzjGhUBb4jk3U2w4s
Content-Type: multipart/alternative;
 boundary="------------D432398BE65A27DEE3869451"
Content-Language: de-DE

This is a multi-part message in MIME format.
--------------D432398BE65A27DEE3869451
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: quoted-printable

It is no problem to move the base directory.

 1. stop the database server
 2. move the base directory as a whole to some other location
    mv /var/lib/pgsql/10/data/base /some/other/location
 3. create a symbolic link pointing to the new location
    cd /var/lib/pgsql/10/data
    ln -s /some/other/location/base .
 4. start the database server

BTW, an upgrade to a newer major version would be a good idea.

Regards,

Holger

Am 26.11.20 um 13:59 schrieb Yambu:
> Hello
>
> May i know the procedure of moving the base directory from=20
> /var/lib/pgsql/10/data/base to another location?
>
> regards

--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


--------------D432398BE65A27DEE3869451
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <p>It is no problem to move the base directory.</p>
    <ol>
      <li>stop the database server</li>
      <li>move the base directory as a whole to some other location<br>
        mv /var/lib/pgsql/10/data/base /some/other/location</li>
      <li>create a symbolic link pointing to the new location<br>
        cd /var/lib/pgsql/10/data<br>
        ln -s /some/other/location/base .</li>
      <li>start the database server</li>
    </ol>
    <p>BTW, an upgrade to a newer major version would be a good idea.</p>=

    <p>Regards,</p>
    <p>Holger<br>
    </p>
    <div class=3D"moz-cite-prefix">Am 26.11.20 um 13:59 schrieb Yambu:<br=
>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CALhHtcANxVwbRYZYyBtZ4G4jJtm+b4vJgs5vp=3D8twS-9YWC41Q@mail.gm=
ail.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Hello
        <div><br>
        </div>
        <div>May i know the procedure of moving the base directory from
          /var/lib/pgsql/10/data/base to another location?</div>
        <div><br>
        </div>
        <div>regards</div>
      </div>
    </blockquote>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------D432398BE65A27DEE3869451--

--Zjb4PajA5TJ0Nd9KqzjGhUBb4jk3U2w4s--

--kz6UKAHL6BbMHzqqJ0iVRwlW42s7UbPzO
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCX7+0/AUDAAAAAAAKCRCKV5yTsxlhuo82
AKDfPQY1p8iJt9kYuss24qSu8PUZ5wCfbKKVz/HuyOOiAO5xR5a/NYXqmu4=
=SJ5M
-----END PGP SIGNATURE-----

--kz6UKAHL6BbMHzqqJ0iVRwlW42s7UbPzO--