Re: how to store data file in Postgres

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: how to store data file in Postgres
Дата
Msg-id CAGDYbUNAt0yb+F-i5yqq00M9MbCQ0Z68LPrd3=WJayDWfrE-JA@mail.gmail.com
обсуждение исходный текст
Ответ на how to store data file in Postgres  (Pepe TD Vo <pepevo@yahoo.com>)
Ответы Re: how to store data file in Postgres  (Pepe TD Vo <pepevo@yahoo.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Fabio Pardi
Дата:
Сообщение: Re: archive command failed with exit code 1
Следующее
От: Shreeyansh Dba
Дата:
Сообщение: Re: Copying Data from Oracle to PostgreSQL