Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjpib-0007Jm-RY for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 18:15:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjpiZ-00037z-Rp for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 18:15:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjpiZ-00037s-44 for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 18:15:11 +0000 Received: from sonic306-3.consmr.mail.bf2.yahoo.com ([74.6.132.42]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjpiV-0001hi-Tl for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 18:15:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547662505; bh=gRgTT6fSRdqck3T/WTZkUA4C+EjqJ/Dc4zzemSKtirw=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=kBBetIfnPAispY/BkMpG/7lKNzaGxAzNO7jvTwfhHgA+LjGzbUUREx02OWKKOVjRUffG3Kevi9DmqlzZQcapxH8K4uzqUPhklMe+5q6w4BVhAiGri+2rC/r4ZzSoDxGP7mZ2k714O+8GW6slqygae57vevVd74ZLiMjJMt0Eb1hnTnwB5SlXGo38meYvTNuCrmhbBLa67NIQav1hijSHKvis3F6BooBn9Oz4pjVGWs8SKROgIGwlSd0As09AuXymxLUxZCLggRldtk7k4TPMbHebTWU58GbNY+zYKDWSbAxGyZ0+/w1roLQg27aUlBdjH2YwwUS/i4pVn08K4xzp3Q== X-YMail-OSG: Rhgjm2wVM1mKwNIuEWyYJ5c4HZBPE.mFe2LWzA.0xltENZgVYsKbAkXONvaTUOY L3f8CBxZ7v5tO6G590EcKbN.SEQgoon6_ekgtgi5At9dIrTeIXU4whAhvf1.e5cBJUFjMIjcUeXO b8c1in.QSyvJewFlhBgSKFadbRXEQMGoXN7Qd.wxX5fLulCbKfNtPCMRWAIP6rhvDa28t8KgVIEZ SqUUctzsUefmYz1aGQ5u77KkI2_E682O_39mYVNj0JIkMtbaugfvDOeIvH299.mlSXtaCoZ1wlbC 7CMK33cRjcytmB8Cz8kMu1GuXKpehCDRU2JvyaRjvoO77oQ7DJTrIUwhfeaQpjKNh..9mWNC3lB_ Lp1GJD.b0WriwFapzJmNNNNoIR0.2bCroJwAz5nY7zgycRWPJTL.cE9tycDses1muGM6mHKuAIdQ TmJHL7Y8pESacN0I7J812_Hevcptev.24vi67XbA5yvMW5KhHJNtwRd4nyS3klYJSgNP3ipGqi1_ lIRK4K0tMseRnr0u2u.wSs_fAcAiaK4NOwRDTxEjq81L34cJ4Apr1CjuPi7IgUSNN7k_Zr9LLXS6 A8RscObfhrQcFZA23.u6GEznalsjB7e_ZMM05EskRImAswxsUxnd8NaRqjlbhL8wm8.xWmSQPAvZ VI3QZdfvRQX04Dj_xDLjm_JAFE2QTuRrDTrGzm2Z9Re3LGat7oaAdorf50CJpeShoqJ6PHzjqJXD Yl9EAJAOb0KzcJGyDoxDidimaQ1icQu3RKEYS4uezjBn2A22.c3d0JzVcZWLzvEfEsYZJD7erkTX 9zP1r3Jxh68f.L56pxk8.ROh3Gfo2aou4nl7aNZMVujgktIgXAr.feewK22gEkA5QYk2JpG_PMf6 vi6PNKl4ixvo6LgbiKuT8axDZ0B2YCUZxeC4EtbMqaaKOk97azlOhbaun645AhqeBVArPF7PXs35 HZC1jZsEUd7fRN.qAztTJ5KZAlVNy58Vb4vV1jWaueVnYisu9B3d16dC57OWGbfF1_CALdDJastc UGCa61G6pXrgfrtRU3nMpqnOKQH2mbIBHCOBtQmF6B0spVU6AaDaYRmmaYQ-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.bf2.yahoo.com with HTTP; Wed, 16 Jan 2019 18:15:05 +0000 Date: Wed, 16 Jan 2019 18:15:00 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Pgsql-admin Message-ID: <557751313.670161.1547662500240@mail.yahoo.com> Subject: how to store data file in Postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_670160_1226672396.1547662500238" References: <557751313.670161.1547662500240.ref@mail.yahoo.com> X-Mailer: WebService/1.1.12857 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 4514 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_670160_1226672396.1547662500238 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello Experts, I created a database named "CIDR" using pg_default tablespace.=C2=A0 Now if= I am moving the data/schemas/triggers/functions from Oracle into Postgres = but the spacing is an issue.=C2=A0 From Oracle total datafile/tablespaces a= re 18G but in postgres where the pg_default tablespace has only 5G left.=C2= =A0 I am asking for more disk spaces, SA is willing to give me another part= ition.=C2=A0 How do I move the CIDR database data file from where it is now= to a new partition? thank you.=C2=A0Bach-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 call= 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 t= o 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 ------=_Part_670160_1226672396.1547662500238 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello Experts,

I c= reated a database named "CIDR" using pg_default tablespace.  Now if I = am moving the data/schemas/triggers/functions from Oracle into Postgres but= the spacing is an issue.  From Oracle total datafile/tablespaces are = 18G but in postgres where the pg_default tablespace has only 5G left. = I am asking for more disk spaces, SA is willing to give me another partiti= on.  How do I move the CIDR database data file from where it is now to= a new partition?

thank you.
 
<= /span>
Bach-Nga

No one in = this world is pure and perfect.  If you avoid people for their mistake= s you will be alone. So judge less, love and forgive more.
To call 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 ap= pearances. But to those who knew him well, he was a perfect gentleman (Herm= ione Gingold)

**Live = simply **Love generously **Care deeply **Speak kindly.
*** = Genuinely rich *** Faithful talent *** Sharing success
<= /div>
------=_Part_670160_1226672396.1547662500238--