From: Pepe TD Vo <pepevo@yahoo.com>
To: Pepe TD Vo <pepevo@yahoo.com>
To: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: create tablespaces and users
Date: Tue, 15 Jan 2019 17:57:50 +0000 (UTC)
Message-ID: <442357970.589897.1547575070485@mail.yahoo.com> (raw)
In-Reply-To: <2088852869.450616.1547563351918@mail.yahoo.com>
References: <858026322.18309717.1547479488317.ref@mail.yahoo.com>
<858026322.18309717.1547479488317@mail.yahoo.com>
<298a21d9-c6b3-e80b-adf5-4583c9df2f70@gmx.net>
<2088852869.450616.1547563351918@mail.yahoo.com>
In Oracle, we set up each “schema”/user for each developer and/or each database login. This allowed the schema logon into their own database and create their own tables/function/triggers, etc.... How do I avoid all people logon into the postgres db but their own schema/pgsql user?
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
On Tuesday, January 15, 2019 9:42 AM, Pepe TD Vo <pepevo@yahoo.com> wrote:
so you suggest not to create the tablespace and associate with the database, right? What's about the owner? Still postgres or create user owner? From Oracle we have 4 schemas for cidr database.
CREATE DATABASE "CIDR" WITH OWNER = postgres --> or new users???? ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' TABLESPACE = pg_default CONNECTION LIMIT = -1; 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
On Tuesday, January 15, 2019 2:26 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
Pepe TD Vo schrieb am 14.01.2019 um 16:24:
> From oracle databases, I have few tablespaces and users created for
> that particular database. How could I do the same for postgres?
The question is: what was the reason to use tablespaces in Oracle?
Most of the time I see an Oracle installation with a tablespace per user, it's to manage space more easily.
As Postgres does not store data in one huge file, this is not really relevant here.
As soon as a table is dropped, the space is released from the filesystem.
So just create the users and let them use the default tablespace, unless you used the tablespaces
to distribute the I/O load to different disks.
Thomas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, spam_eater@gmx.net, pgsql-admin@lists.postgresql.org
Subject: Re: create tablespaces and users
In-Reply-To: <442357970.589897.1547575070485@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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