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 1layjE-0006SH-7B for pgsql-admin@arkaria.postgresql.org; Mon, 26 Apr 2021 10:44:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1layjD-0004DR-41 for pgsql-admin@arkaria.postgresql.org; Mon, 26 Apr 2021 10:44:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1layjC-0004DK-Ed for pgsql-admin@lists.postgresql.org; Mon, 26 Apr 2021 10:44:34 +0000 Received: from sonic313-56.consmr.mail.ne1.yahoo.com ([66.163.185.31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1layj5-0004vC-24 for pgsql-admin@lists.postgresql.org; Mon, 26 Apr 2021 10:44:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1619433863; bh=uh7gL+oiTymsaV2TNm27/Ue0lrMpbQP652uWYNxAFvQ=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=CQE7Xkn4iPschDIYvI7yWGyBx/N/THNp1KMsuixVt+rQnd0hkxLei8VrszygaHSFiuur76CLz5s8a1QSsz8KEJJgSYIWENA4MHzh4lCH8nmRhYFIAdwv7Me9yXg/Cp/bPNmNw+u5UZmwdMW+bvJDayIKZQjs3WM+t2dm+hDHFxh1E+Qr98svmXTYpeeJ/vRJvfJZwBOIyPuRb6/7wv5XXiXSafQOqybUvOsfbAoO+YzqNCzanzOvX7eMl20XstrQ8hS3TsP3rcYIs0q7MlcRXuhD5EAPwLlwO0q6COaa6g948nI/L8Ihu74ZAKsCS1h0dj/jUemghjow/pqnRqoTCw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1619433863; bh=BGIdTLB5Ul7Bw1OXuqCfEVcOf/El5eustHxSN0rDlaJ=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=PBmFpA7z4IS4MgwOtUei70eAMdS4AcAj0iXq0Q/+1SfPQA7XEgHSradR9TR9TdWuDdyt5z5FdzI88WMujnF2nCvlDO1eQrIJCSttUic1MDOmWLfGiYBOWA7YhBgr2rUTRyv+D+i4D9CvqY9DEAP3JFths7zW6a30BC+xrlMNsBu9OfOneQq/qhyT3FSc1jOC4VyaPwmlgXYivsxNwoQXQ6Mh4f6Y6ABoKzFoJiEEffjJnpJMHd4JSM0l6dsQememzLgaJRoXudgX/lFKMA4Ch12FNa3TpjIOpO+462aflZ3jtVrbR4CzWkgHhlBy/BJVFEuWFdek1RdH/GOuNjgo0w== X-YMail-OSG: kRwmyO0VM1mP8.9bEQea5a_Z45eB8IwFZQ67XcVT10vqnPvfm61FAdOmQY1ueU9 f7Ui5D04F268DVfOLNoO8wXfdWl8RzitMZP7ZV0R5SFM.ndjwcvyL7oXRGH.KksKpV0XOOj8B3qf PJcgXp5QsxgKKy3eF2TGuOKNH5AmX4cRvY3sc9ETklgx3Edt2O3sH.oEZKJIZ3KaLTCucLIb2Hfr RwCUKGOyawyzIqr7Xa8yNggbWF5UW8sqoQVuw0soL6GGzxxwNvLh.c9S2gmmmZOgzVW2jXbHLxYG 7pYAn4EADii87QtpAYpsUZkgJj_QZi1IUCoi9AyisuIoeyMG2bQjvMsLrK_xV.IAFKFTSrbFsdPS BQ9kPAweYcZU5Rm5Gt8QhhHQuzv6K9lpg8CtNC.PQyYSPl7vLYsNA0a0c33UqV9ByFReGIOi8VSX GeqmpTM9cCV5hSupmkGAKcnwOebDVBCKu5InvSf5p85tT4gmhPNYKw9R0ZqgrEl0dOz4m2_WkIle QIMHTRkKXbFvt8bDvZxCRmgyibFss1WAgR8NLa4vwZKbRcE3JDXNPWet_v8AXJ8gK7Qk4g5WUkYQ ocXNhFbFVc4Ae0Y3SOC1DEjkxzYcWIIisnC.9K4X8J6tWAKRQ41MZkcFbG9hLNvfI8fHviY8uI2a CjxfeQSpAYd8kuLoz.mvBLSEtw6fRyZnxoXSwEKZ__p5gZgu.Aq.XeObF4qBhraMJKUPFOis4Anf l9JQWW39aMy.zRyKsKqJW.Uiov6pcxtp4GUWz2hsMQln2LRoEMO8sgiZ9FEYVbe0LiMpX.3K_a_a bFmMBd1ktajseNFcYw1JZh.Y1WEjFAmEccnct8NTB4WA9Nu34lNkHFuk1_gl6_xqkA0Egnf_E5sP nG20EnC4T4NSe40.G8KrMK2.IqxUHFkBaiD.67AAHNY48DMtv3pW0QfTZ3nQ4gNA93piZHprkuO0 LzR7sAoKnNndfuYnj_D5Oi4wmHap64Mq_abpwcPTrv84U6X9myhDMPbtQrGmo0FAkozJAYTqwZdf ytzhwAG1A_706VORosR4xlwV9qQSmU_sBKP9w584ie6oVhTDbsOvhOq3pYVQXkkGkFgqaHnjNRjh uWTZ5JFtydOpROcP_kzMhS3f57MdOR2Ewvm.98N3oFgDjsDdZpEA2U_D1gC24XpHWoHF54V3CPUA 4q9LAa1xM5Fj57QERTPJkRIYLYBY_gEMwjp7FJpq_95MlYS4KAxoVycsdZUxYjYpPiFjzuLua.36 5KpHpE1WHorxIJpIMeYduCpJPPg5LvM3SUwp2pnF4D9ozxLBIwi0MnGz0qjmu6bxFc32LeuL0uoT JqTAU55crvQQANnfP3VvpL1pjJaGHizoFk45DB7OekBi6udDaPCHCcJoBmdoTKzzz.hFSUsgcjH5 dU_3NA4zPGNb7Tjhm5M.vDhCFyXZdAgaJICG6wqmZBuLB9ckT6YfPeJhCUPk0SPx7j6ltfUu75ji UFU_wSamqHLJ09xo422GvVp7aBuHaqwdlI2PLhmuMKsJAIK3BmyvxJgccUwmA.fIuNnGhg.UQGrI R0JUdMRhxX8y_SPKcwSDzftO5FSMeL.i9ySXvNGeaqLEMP8Rp01YjJLAvSwi338EtLurpmQ6Nut2 _A72FFQmUd6M70Jt6z1zkK29slrZXdpo2PLTNXoxTf_GMGhFJ9DANDzeA1UmpIkswFF3SZmgcxk7 _FRcbSh3TnanKeDnH_4ifsfhUvTnENW269PfTXAhrlWV.2.ZAe7Iy2dKLcY54WMtSNeDDUSKTmWI 87D3y1kdQsXuAPyNeKve_dzycJR0q5DmOrQyyalmUmg3AqkhCkUT91x43t_tV_tGCaqdmo8qE2rR JWdBSaV1mCca7WrSbMmWVvagau9cvYtd1_CoQmkGuxGaOUE2QH1WYJIcbD4JycYqcog1CToOUMN_ 825NWl2Ks1Fs.dJTxyFTgovLJwhUydlPADObW.qRBQl2wwZRa1KB8d.2SWSbg2Q40yorSmFEO6e4 7_cM8MInm7zayy.lt_PKQGx0XmcczwIZGlp3jjUSikmYnXFbSTUZWLvKy5C9SZDpOE4s5cOtUmfr isLHzZNPn9PYuVqF_AmpucrPRlwg0iRFY3KR7GlT.yCy.mBAgaCy4Uy7aLMlypyAnfMMm1T79eEk 2UKn7UdlCSyX5C3m5Xa6iq.AA3ymdGJgq8NSpItGJsurltcF7HimA75nf.Z4310q_UdBGQfWqUc. 7cPACLvMwnNnTCtGCqu1YVGuLsrbSGLei4C8NuxguKLKkJj.9a26BlbFCNdbxLrrRJ3kSB1Ck1WR s5b5kzBYd90Hz0egQdb6TegvPqPDhTI9ReZD0ofN_yNx9FMhdBMgPuBNnhYScOYZyfhp4isbNIoZ JnzqtyG5VrusMX.X8tORCWddPJiq7iiDcgwCvpsycLoA_oW4PjQRsnxfMZanc7b6w9g4acy0fnJ6 8ixunTtUF94p5xaFWCQGQChDp_4GX1ppCPoGcLOW4Zn0OPKauxIq3ey4Yosyb6KNpd82_3e0dBPZ ZLBobZ98sUKMOorlC8QXwteyG29E3cIt7l7zgPYwRdck9hC_Elo07rGqRAtF1Zn18z0QvOlD0AZ5 lwbNkmF2AzCPEeXMUkOi.cL9SoeUcnbErUVq6x7XOhRVhOwq4mFwLAM1qakGjYbTx0_PNOFP5op7 t_3KDTuDXmRdaBBB0bIHcvvTaVehPODe7fWRsXTMoQSssKyV1gd2xP.YFZPcEWUsG1rSjPkQj7fh JZzj1igWmjL1iX1PRGLguKTJOcH0mtTSVa_YpuXHaafHFvjvrTeFnU60a5QXrUvFeL7nCEyOdtLM zb82vUBHO3cP6yYpJWlOL8aTI4kZ.79FJgkkFinJBJu4vgXjIvUT8yjMRWAxT74CfOlZRjpob9gK JzVM- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.ne1.yahoo.com with HTTP; Mon, 26 Apr 2021 10:44:23 +0000 Date: Mon, 26 Apr 2021 10:44:17 +0000 (UTC) From: adnan salam Reply-To: adnan salam To: jeff.janes@gmail.com, Jeff Janes Cc: "pgsql-admin@lists.postgresql.org" Message-ID: <1655532367.874692.1619433857339@mail.yahoo.com> In-Reply-To: References: <714987954.864091.1619355382976.ref@mail.yahoo.com> <714987954.864091.1619355382976@mail.yahoo.com> Subject: Re: Facing issue while upgrading from 11 ro 13.2 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_874691_420159940.1619433857338" X-Mailer: WebService/1.1.18138 YahooMailAndroidMobile YMobile/1.0 (com.yahoo.mobile.client.android.mail/6.27.0; Android/11; RP1A.200720.012; a71; samsung; SM-A715F; 6.2; 2183x1080;) Content-Length: 4951 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_874691_420159940.1619433857338 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi ALL, Thank for your support.The issue has been resolved as the size of my databa= se was only 8MB so after executing the delete script the size of new tables= pace location folder shows the same as 8 MB of folder PG_11*********.=C2=A0 So after upgrading the bigger size of 2GB database and executing the delete= script it shows change in size of folder PG_11 from 8 MB to 2GB. This time was upgrading from 10 to 11. Regards, AD Sent from Yahoo Mail on Android=20 =20 On Mon, 26 Apr 2021 at 1:03, Jeff Janes wrote: On= Sun, Apr 25, 2021 at 8:58 AM adnan salam wrote: Hi support, I am facing upgrading from 11 to 13.2 I am trying to use --link but it is c= opying the tablepace files to new location instead of creating hard link. Need your support. I can't reproduce that, it works as expected for me.=C2=A0 What analysis=C2= =A0are you doing and with what tool that leads you to this conclusion?=C2= =A0 And what=C2=A0is your OS and type of filesystem? Cheers, Jeff =20 ------=_Part_874691_420159940.1619433857338 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi ALL,

Thank for your support.
The issue has been r= esolved as the size of my database was only 8MB so after executing the dele= te script the size of new tablespace location folder shows the same as 8 MB= of folder PG_11*********. 

So after upgrading the bigger size of 2GB database and executing the de= lete script it shows change in size of folder PG_11 from 8 MB to 2GB.
=

This time was upgrading from 10 to= 11.

Regards,

AD


On Mon, 26 Apr 2021 at 1:03, Jeff Janes
<jeff.jane= s@gmail.com> wrote:
On Sun, Apr 25, 2021 at 8:58 AM ad= nan salam <adnan_pk_1@yahoo.com> wrote:
<= /div>
Hi support,

I am facing upgrading from 11 to 13.2 I am try= ing to use --link but it is copying the tablepace files to new location ins= tead of creating hard link.

Need your support.

I can't reproduce that, it works as expected for me.&= nbsp; What analysis are you doing and with what tool that leads you to= this conclusion?  And what is your OS and type of filesystem?

Cheers,

=
Jeff
------=_Part_874691_420159940.1619433857338--