On 9/01/2010 10:53 PM, Amy Smith wrote:
all
For dba, do you create a dba user and grant all privilege to 'dba user',
so you can create table, etc ?
For a team, do you create user for all team member and tie to a group ?
Not sure the set up for postgres
However you prefer, really.
I prefer to create a role that owns a particular database and GRANT
people who administrate that database access to that role, but you can
just as easily do DBA work as a superuser if you trust your DBAs to
access _all_ your databases.
also what is best way to create a production and test region using the
same database ?
If possible, don't.
Use separate databases in the same PostgreSQL instance or even a
different instance.
How to use mount for differnt region.
I do not understand this question. Can you explain what you mean a bit more?
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
