From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Post Install / Secure PostgreSQL |
Date: | 2010-09-13 17:38:29 |
Message-ID: | AANLkTik7SwMLm4jM=N501XLUWhOqMH_n8SrJDrn51bg0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for all the assistance and clarification with my new install of
PostgreSQL. I am able to switch users to 'postgres' and verify the
default home directory for 'postgres' shell user:
[root(at)db1 ~]# su - postgres
[postgres(at)db1 ~]$ pwd
/var/lib/postgres
I am also now able from the documentation to understand how I can
"create" a database and "drop" a database but thats about all I can
figure out for now.
In MySQL, it was recommended that you create a power user account
rather than manage the database with the 'root' account. Is this also
the same thing for PostgreSQL? I know you guys told me that there is
no 'root' account but there is a 'postgres' account which appears to
be the equivalent of MySQL's 'root' database user. My question is do I
need to or is it recommended I create a 'carlos' account and grant
privileges to that user rather than manage the database with the
'postgres' super user account?
test=# SELECT * FROM "pg_user";
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
postgres | 10 | t | t | t | ******** |
|
cmennens | 16393 | f | f | f | ******** |
|
(2 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2010-09-13 17:38:46 | Re: hi, how to let the inserted tuple visible to other backend when current backend hasn't finish? |
Previous Message | Merlin Moncure | 2010-09-13 17:34:46 | Re: I keep getting "type does not exist" on compile of this SETOF function (list 2 table) |