Re: create tablespaces and users

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



yes, we want to migrate oracle to postgres with a new name of database in postgres and keep all the schemas/triggers as same as oracle, not migrate oracle to postgres using the default postgres database.
 
Do I need to build a new database name with all the tablespaces?

CREATE TABLESPACE cidr_data LOCATION '/ssd1/postgresql/data';
REATE TABLESPACE cidr_data LOCATION '/ssd1/postgresql/data';
CREATE DATABASE "CIDR"
    WITH 
    OWNER = "PSmasteruser"
    ENCODING = 'UTF8'
    LC_COLLATE = 'en_US.UTF-8'
    LC_CTYPE = 'en_US.UTF-8'
    TABLESPACE = cidr_data
    CONNECTION LIMIT = -1;

you can keep the  schema / trigger same as oracle or transfer data in different schema by creating new as per your requirement whereas the public is the default schema in PostgreSQL.

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 Monday, January 14, 2019 11:27 AM, Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:


Are you talking about migration..?? If yes, you can keep the  schema / trigger same as oracle or transfer data in different schema by creating new as per your requirement whereas the public is the default schema in PostgreSQL.

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Mon, Jan 14, 2019 at 9:39 PM Pepe TD Vo <pepevo@xxxxxxxxx> wrote:
thank you.  
so after create the database, I need to create user and tablespace with each ownership
create user <user name>;
create tablespace <name> location '<directory path>' owner <user name>;

what if I transfer the schemas/triggers, etc... from oracle to postgres, are they stayed the same or what?  What is the best way suggestion I need to do?

thank you.

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 Monday, January 14, 2019 10:48 AM, Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:


In PostgreSQL tablespaces and user all cluster level objects. tablespace is just another name for a folder where the Postgres server process owner (typically “postgres” system user) is the owner and can write some files. 

In PostgreSQL All objects stored in default tablespace i.e. pg_default. 
You can create or alter databases in the tablespace and assign ownership for that tablespace.

Commands use for creating user and tablespace:
create user <user name>;
create tablespace <name> location '<directory path>' owner <user name>;

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Mon, Jan 14, 2019 at 8:55 PM Pepe TD Vo <pepevo@xxxxxxxxx> wrote:
Hello experts,

From oracle databases, I have few tablespaces and users created for that particular database.  How could I do the same for postgres? 

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





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux