pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to store data file in Postgres
5+ messages / 3 participants
[nested] [flat]
* how to store data file in Postgres
@ 2019-01-16 18:15 Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 2 replies; 5+ messages in thread
From: Pepe TD Vo @ 2019-01-16 18:15 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hello Experts,
I created 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 partition. How do I move the CIDR database data file from where it is now to a new partition?
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 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 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re:how to store data file in Postgres
@ 2019-01-17 00:36 chris <yuanzefuwater@126.com>
parent: Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 0 replies; 5+ messages in thread
From: chris @ 2019-01-17 00:36 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hello there,
I don’t know your actual level of the transformation, you can create a new tablespace to the new partition and then moving some of the tables to the new location, or shutdown the pg and create a softlink for base dir to the new location then start it again. There are solutions, choose a good one for you current situation.
Thanks,
| |
Chris
|
|
yuanzefuwater@126.com
|
签名由网易邮箱大师定制
On 01/17/2019 02:15，Pepe TD Vo<pepevo@yahoo.com> wrote：
Hello Experts,
I created 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 partition. How do I move the CIDR database data file from where it is now to a new partition?
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 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 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to store data file in Postgres
@ 2019-01-17 08:47 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 1 reply; 5+ messages in thread
From: Shreeyansh Dba @ 2019-01-17 08:47 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
You can create a new tablespace to the new partition and alter your
database 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 <pepevo@yahoo.com> wrote:
> Hello Experts,
>
> I created 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 partition.
> How do I move the CIDR database data file from where it is now to a new
> partition?
>
> 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 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 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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to store data file in Postgres
@ 2019-01-17 13:25 Pepe TD Vo <pepevo@yahoo.com>
parent: Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Pepe TD Vo @ 2019-01-17 13:25 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
thank you so much for input. Can Postgresql database have multi tablespaces or just one?
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.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 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
On Thursday, January 17, 2019 3:50 AM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
You can create a new tablespace to the new partition and alter your database 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 <pepevo@yahoo.com> wrote:
Hello Experts,
I created 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 partition. How do I move the CIDR database data file from where it is now to a new partition?
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 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 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how to store data file in Postgres
@ 2019-01-17 13:54 Shreeyansh Dba <shreeyansh2014@gmail.com>
parent: Pepe TD Vo <pepevo@yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: Shreeyansh Dba @ 2019-01-17 13:54 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
PostgreSQL comes with default tablespaces: pg_default tablespace stores all
data. You can create multi tablespaces as per your requirement.
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
On Thu, Jan 17, 2019 at 6:55 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
> thank you so much for input. Can Postgresql database have multi
> tablespaces or just one?
>
> 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.
> 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 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
>
>
> On Thursday, January 17, 2019 3:50 AM, Shreeyansh Dba <
> shreeyansh2014@gmail.com> wrote:
>
>
> You can create a new tablespace to the new partition and alter your
> database 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 <pepevo@yahoo.com> wrote:
>
> Hello Experts,
>
> I created 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 partition.
> How do I move the CIDR database data file from where it is now to a new
> partition?
>
> 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 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 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
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-01-17 13:54 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-01-16 18:15 how to store data file in Postgres Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 00:36 ` chris <yuanzefuwater@126.com>
2019-01-17 08:47 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-01-17 13:25 ` Pepe TD Vo <pepevo@yahoo.com>
2019-01-17 13:54 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox