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 1gk7fz-0003cO-Ou for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 13:25:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gk7fy-0004BQ-Ch for pgsql-admin@arkaria.postgresql.org; Thu, 17 Jan 2019 13:25:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk7fy-0004Ah-32 for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 13:25:42 +0000 Received: from sonic314-13.consmr.mail.bf2.yahoo.com ([74.6.132.123]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gk7fv-0007QU-0R for pgsql-admin@lists.postgresql.org; Thu, 17 Jan 2019 13:25:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547731536; bh=0aIypTcTZkXman+w+zNexhVkTy4ixdT5AIJo02yfufk=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=rIqy6befxvurawMulq+3H5XC678qkVjlFTU+Erw++o0ZdTg6AEtrXUps1IPT5Slog5neLHcp/ebaV36pekaz+kAVC17d99kV7RtHtUUDiPzdibaDGUxvpUDpYvk+C3YSTkl+QWRkSB9aIO611p6dLvS5DN039mJ8+Ine3oPiHdr1U1i6dt2BrP/aZHJu54nGcylUVF74tXFEU34AkeNwyf8v2X/JQQwGZxs6kYWUjwi05SNBaae1/+v3qlE0/Cna80AQ+T6OeNybSirfE4+8B1vYk6/TaVfQQRCItAgkxiZExgYn2/oU0y5pooViMH/q4dvQVQZ/jq7NTBcUs9zorg== X-YMail-OSG: iQtbgPIVM1kCq6tOQK_FLFbhMkSREtcwZ.8NlTdyWZ.0XBlwcTx6hpc_OoTvF8t zM1Qc2V.QBUnQ0b82GYQBG9tApJ1zGy4iGK7MwwlPWfpl6fRxKDGxBFJrAb5arfbC4MU4TFcgeUc cZsUHs18WlXlMDWHFDJ6S8F9rttODk9GNS7seMTE2qIrAbg6PIDAICIQzJtgJyeR9hiZDZyTWCYA jPR.rqcfWU7KqC8W8wTM3DG24gNVIH8bsUeatpOqexMFGRT_NbFkMReV8ldcuPj8wDHTNog.sJvT Vhgmq_6RO6OWeKH_9ZLo5yXtugZ4W56yt2E114hjZBEGeuNI_s5lk4QqLz7WZEcwjIwgN.qUZL1G uoFMBQAQIH3fWQj4_1un2akYsvvH.7.rjEe3__BmLsmq6GS1yw66N3ux8ZOON5Iw8Zw4MOrYoFlN PNGMCMvKylW7T9MMcp0W_v.pSGJXzjiUh4HJ3dzqz0dRLyX_CwhD0dmAZKgubQRgWk6gnNoIdLji zuR.QATWh6bfZAuzkU7IIr6e3kvPDNSnhYdBrpWi4wpU0q5Tb8mIoXxVAIAbIBkc6N3DfxSU67pp JTu.l8T3wy0TZ8FIUlgau.T8iJRozJmNd_SD6HCOxX.jsyLQxx6hthTPC954IYn4P.1jurHgVDrk nOtJwyvzcdFADnhK6JMPrvfFJhHm3xqVSCaGe6XqL10Er3bKrgpmu7EeEzpug_uzV2EbjsPUxR5d d3GWCy3lUY70zHSpWv6KAzO_CXbyf3vc6WJD560M9BWgnClHtE_syeWIJUvfCyYMNhPIaSvLT3CA K_pa21X3BahMAmkBSrZsMfSRXroVjrqRdJUJ1_oZjsHMDJKxJoni_Vkpw2Kh.UwLHhkerkLfU567 esK8q4zMmttpC20quMrxtbzJ_ytqsK38Yb8hu9DDCpNL1hq6.yU9AjVeo99patq1q_IQT2GSxtv. Mh4SBQPu_I2fWzrCbuRor8HW0xgtB7ooDSooUerdluOTjzpjtJUZTOUfPLgme11lMhr7z6PwNvo5 v27LvneNMf2CCSnSsf9hmuxu_Lb6uGtqScecqOYSkB2_XMeulnMQiKigiideOI0bcUiyeAA-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.bf2.yahoo.com with HTTP; Thu, 17 Jan 2019 13:25:36 +0000 Date: Thu, 17 Jan 2019 13:25:32 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Shreeyansh Dba Cc: Pgsql-admin Message-ID: <595278937.1118720.1547731532152@mail.yahoo.com> In-Reply-To: References: <557751313.670161.1547662500240.ref@mail.yahoo.com> <557751313.670161.1547662500240@mail.yahoo.com> Subject: Re: how to store data file in Postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1118719_1704351649.1547731532150" 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: 11357 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1118719_1704351649.1547731532150 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable thank you so much for input.=C2=A0 Can Postgresql database have multi table= spaces or just one? v/r,=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=20 On Thursday, January 17, 2019 3:50 AM, Shreeyansh Dba wrote: =20 You can create a new tablespace to the new partition and alter your databa= se CIDR set to new tablespace. Thanks & Regards, Shreeyansh DBA Team www.shreeyansh.com On Wed, Jan 16, 2019 at 11:45 PM Pepe TD Vo wrote: 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 =20 ------=_Part_1118719_1704351649.1547731532150 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
thank you so much for input.  Can Postgresql data= base have multi tablespaces or just one?

v/r,
 
Bach-Nga

No one in this world is pure and perfec= t.  If you avoid people for their mistakes you will be alone. So judge= less, love and forgive more.
To ca= ll him a dog hardly seems to do him justice though in as much as he had fou= r 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)<= /font>

**Live simply **Love = generously **Care deeply **Speak kindly.
*** Genuinely rich = *** Faithful talent *** Sharing success


On Thursday, January 17, 2019 3:50 A= M, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
=

You can create a new tablespace to the new partition and alt= er your database CIDR set to new tablespace.

Thanks & Regards,
Shreeyansh DBA T= eam
www.shreeyansh.com=


On Wed, Jan 16, 2019 at 11:45 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
Hello Experts,
=

thank you.
 
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.
To c= all him a dog hardly seems to do him justice though in as much as he had fo= ur legs, a tail, and barked, I admit he was, to all outward appearances. Bu= t to those who knew him well, he was a perfect gentleman (Hermione Gingold)=

**Live simply **Love generously **Care deeply **Speak ki= ndly.
*** Genuinely rich *** Faithful talent *** Sharing success

=
------=_Part_1118719_1704351649.1547731532150--