Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kiHuo-0004Il-BT for pgsql-admin@arkaria.postgresql.org; Thu, 26 Nov 2020 14:06:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kiHun-0002Dn-9L for pgsql-admin@arkaria.postgresql.org; Thu, 26 Nov 2020 14:06:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kiHum-0002Dd-U7 for pgsql-admin@lists.postgresql.org; Thu, 26 Nov 2020 14:06:29 +0000 Received: from sonic316-11.consmr.mail.bf2.yahoo.com ([74.6.130.121]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kiHuk-0008GP-AY for pgsql-admin@lists.postgresql.org; Thu, 26 Nov 2020 14:06:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1606399584; bh=dt1Odun30MalO4hNTxKURZH+/7zTliQDjkzf1zEyz4k=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=U8W9MsBW1+M3pg2RkZ+KijmJc+lcr4GP9p+fsyi/RtMF5IH+f/BltqAluzVGZzkw1cojMgB4gzsqOSZaI9Rgf2hX1F8uSkp4t8GlkItGm8OT3tUT11FtvlxTk0QDw9+ZeYZ92RCn1egDWqhKpT02lghWJqND7qv70M7zvso+eDe2pjAR44B1AQuibGVVcsaga1gpoSPT2qaPE4U+dTPRpajdNTHCLWw66JL0tBZwvD003by656YvJIQWUDBtlod87jEmdugGyKq5A/alMNIF5uRQzHTQ/wu0di4qrAwdTgsg6ZmTBCbyAGQcgq2VFVRiOqXCdyQ2oCcqSGEWAX7ySw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1606399584; bh=mRdmbd5m/dydJPvg9K4YlSSShTyyH6d7tXoSzCMTNdY=; h=Date:From:To:Subject:From:Subject; b=A8c07XDj2K4tkbVfFF4Rh1vjw4PeAUiNDsxCpNL8DXhBeal52y6Ks3gjDe2Ot5yYnVwjRLUN0vYDV18CTJgiiCR0Tb5Gbt7K3tfyc5/XeOLrgHF2in0E0BXiujQFUva5TekbGGfd+IZ4NDCjBjr0Az9Ki6opzr/tDIYMNihxd+RXIkzJwpCGzWb+n30xEYG8COR+QmA5Npc3u726ZscVT5O5zAqJz3RG4a3bWO9NaxzPXB2R9tKCQQWwzQlgko7v1rVwzXxIpRL5J5Tbht6BT+NoNeANiNudLi6pXZPY2uujRG0IITnv3HUqigXSvibUXY8JkJ+yOFkas475wSDueQ== X-YMail-OSG: YX6KK_gVM1kQS.IccZhQKOOarY7wLTL7gkDFRTfNKk5y9dnFxn_LuldV_6N24Er j9RbMveLbry8rmmqhEfgqM8uzv19uewnWXUu.F_mcUeE8uCQ0xqINomfMaVYdHP2sEQOLMg7x.Oe aJVk0RCGuzK3NzfuJmms6CeoguiYnTmUgF9erqXhkdKS_qx0hcnUAIoYHgpG01.mPYd7YCEr_Rr7 3YAEYSkRtgTKZLbGjXnr4xzoGv.Pcfevd3so5X8wh1Z7yUkMHVmsaxF68tkDfleZCIlqelR7tm6v wMcox8DCqxV7700cfYvLUDDWyprVSgAubTxezXPSuH9Qd2g13sd58qRviUr3hG7Kmu125bpwqf5N op4qh0jZY6DYw0C.INCMnY42oYQurT31rXDHZMFpv5hIOnYthwEF_0uCGtX0tvxNKw9ndq2UiDiM V9pLPky.RVbHPFF6KBdwzxquIAPyTq0UooyM.VLCDhpAxe.bCOeXNHFXhY9eIl1.tJv07TRcrwzr FkDlcg4WsmQhwmDd1RmMdXELJpcfVz7M0df_ktMbFTA_Y8WZmgvEOLUrWNRiYr6dukpOvP9p0zw_ O1gYldyHd90BapFu_6oiY7j21_Cjw.2bPCID7ruPIVHno9FjR9JriZkYWUo6HT9hC8dhXl0GOh3z Yb0EqQfv83J0wJyC1q2VlyJgke_cynGcCuL0Wr6aIs.nSoaTyIDv.fns0l3oggRLRVQApT_Azon5 4HAz4TxuARQUHT4Dlhon.AyOmVf_iyLTt44yl7u0vImDgGF7i2Ygu.VyVRmCqy9VFaSS_Sr4fUod O4eRu6XO.J9KGHxpEO8.qwa.q1zvIDKPwx_tY0ryn0a34uV9wfGwXlEru25XWBI2Q4AU_DdTCwaM _hPPvehK1m.hApzzaQUBcC8G8SPBvsvjjbKtctfQGVFA5qT4qEZEYwyf5IDN7CuqjaU2s87QRwR6 UFcLWi3eeRnjVePOQbQ6iR4nSsXiZSB1E5GdfmlAgJHYCeb4.Zs7BSL65Ln_me04rgDOMbtiuw_E 1wF7zq.TsN7JnLW5OcnH0kfjKbEl8zG2QiuKyWqyboerxu_89ZAdDqyDEuE4N3Y3PC8onIFVJ81T GtSaob.ko23AOxIMHFrm_UrMxmAap1nZDqyye1CoLf7rToOwXxiyzHeqglWREvnc8QvM6IUhWtms .t02yIjizlsRvHbOXY67UdihYw57.fcfiWl_IfA.M61JWAid7C9R8p2.rxwwYG5aJRPaY0aPulYw XnH0KLFv8.qCjCw7Ewl3Z6cUzX25yw7U0l7ugw9JMcI4xrFfy.97l5M7sy5zIwSy.R7qcexx6_vW pBwlqrQUoyKTFb62GO8X1zh62Yu_647GFW3.HcT3jcNrLlZY8mll0RGAIYhunYG.BMswO4OMVmov zorie7xXuxA3EiB_IlufOITcRXtzpnpFTRlpaqESTv7QVN4BGulnxsmaVCgN1AmeRPh_KOAAy5Gc ihBy9_xiqqBNTzCCUX3Ls_oWSPaZi9sla92ttgNPgij9F5kx0UFHWKjW3X.NtjeBDV4DgVoXxq4h s_0QbO6G.CVI2.DKewyUx7_cqfD8Kf5sflW9k3_83hiWOPQtz0ZC5LpZS..S7DWEYkeEFX8iLdaE xd5WQlsx8ttl0GrcY_WYwpe2hhwfXcwjIPtORVPr3S.ljDxaRvIR8YaLIZ8kQTJz482Uly09aoRN um09B.bmju9SoULDYsQZvErlknAwIL.W0hVhz0FWN8MNzB5GCLZ5S0yMsxHbQx_oOHwwY1Ztfx8I 3F6dFzTMqN87RUEMt05xENlnz_LuORIRn3yR1VUT.7VCIufKpi8Tvv8wU3lbaeCNiucNKSSiwj92 cQp_f0cVcKXu6yW8CLqa2DSZOm6rM1BkSnKztFMj4CxWb5DcLHUngKJjbK4FokLRLg4RnfgUvnxN XdJiyjwQPvIpLCnxtQC.84KXIj_B3ZACQfI6BED6UqYPcH06JMet_wtTG7GCCvkeLS1hvBw2qBiO wOvjbjVzjGrQR6jDymtbkMRwqQW9LQ6takOB9vpyHHJudVq9e4WqwWpGQvEwX2N26nQ8fREaeK_v l_fw2uLleAbkn9tpw3bRoD3uHmYs1gPZwoC9P7uRva.C2aYSJFhqacM_1gY7daIYNLZGVhl.NMAw qEQzJ43yqhJDqceZfKAu0iS9z4N_MMw73XY0LW0j__rlDYTytIxkyYqDXWi8xMiXNqENY0IIw7qv 8TFgCgedqr00cHsUO8knAa0DzKfb5flq3ehg_IzMroh1AQH.vQPXtvoAridMO.GWkdckerZudc05 6GN3sKQSdzMY1abZ0IVl0HFRWm23FSJh1jikzi2VPGn5cItSBnDGFNNPRoVBk8ofk9DXFaweuEVH OKYeeaFEFUVmHUZCtRZL8isf6_TONswc6dvXuYDIRVfnb6_Fh5AfBsPBnXKhFoos_EKhtqxFXVSR J8LQXaysXBhCOan8ibEvAuv5lURJkQ9GzFuQh7AKGus.LijaPmhYsX3nG_6KV0iYWQRvaUTmvcdj 7EYUCPI4B_F0nEQsAhlg- Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Thu, 26 Nov 2020 14:06:24 +0000 Date: Thu, 26 Nov 2020 14:06:19 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "pgsql-admin@lists.postgresql.org" , Holger Jakobs Message-ID: <2046891776.1111378.1606399579861@mail.yahoo.com> In-Reply-To: <31b748c7-d728-9d8d-fb49-b6b935b8295b@jakobs.com> References: <31b748c7-d728-9d8d-fb49-b6b935b8295b@jakobs.com> Subject: Re: Move base directory to different location MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1111377_126491130.1606399579859" X-Mailer: WebService/1.1.17111 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36 Content-Length: 8006 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1111377_126491130.1606399579859 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Morning Holdger, since you are mentioning "upgrade to a newer major version", would you plea= se share step by step how to do it in replica?=C2=A0 I have tried to migrat= e=C2=A0 v.11 to 12 before and failed to upgrade. v/r, Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l him a dog hardly seems to do him justice though in as much as he had four= legs, a tail, and barked, I admit he was, to all outward appearances. But = to those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success =20 On Thursday, November 26, 2020, 09:00:48 AM EST, Holger Jakobs wrote: =20 =20 =20 It is no problem to move the base directory. =20 - stop the database server - move the base directory as a whole to some other location =20 mv /var/lib/pgsql/10/data/base /some/other/location - create a symbolic link pointing to the new location =20 cd /var/lib/pgsql/10/data =20 ln -s /some/other/location/base . - start the database server =20 BTW, an upgrade to a newer major version would be a good idea. =20 Regards, =20 Holger =20 Am 26.11.20 um 13:59 schrieb Yambu: =20 =20 Hello=20 May i know the procedure of moving the base directory from /var/lib/pgsql= /10/data/base to another location?=20 regards --=20 Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 =20 ------=_Part_1111377_126491130.1606399579859 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Morning Holdger,

since you are mentioning "upgrade to a newer major version", would you pl= ease share step by step how to do it in replica?  I have tried to migr= ate  v.11 to 12 before and failed to upgrade.

v/r,


Bach-Nga

No one in this world is pure and perfect.  If = you avoid people for their mistakes you will be alone. So judge less, love,= and forgive more.3D"Emoji"3D"Emoji"3D"Emoji"
To call him a dog hardly seems to do him justice th= ough in as much as he had four legs, a tail, and barked, I admit he was, to= all outward appearances. But to those who knew him well, he was a perfect = gentleman (Hermione Gingold)

<= span style=3D"color:rgb(128, 0, 255);" id=3D"ydpf8dd9bc5yui_3_13_0_rc_1_1_1= 381789421038_7867">**Live simply **Love generously **Care deeply **Speak ki= ndly.
*** Genuinely rich *** Faithful talen= t *** Sharing success




=20
=20
On Thursday, November 26, 2020, 09:00:48 AM EST, Holger= Jakobs <holger@jakobs.com> wrote:


It is no problem to move the base directory.

  1. stop the database server
  2. move the base directory as a w= hole 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 schrie= b Yambu:
Hello

May i know the procedure of moving the base directory from /var/lib/pgsql/10/data/base to another location?

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