PostgreSQL on CentOS

12Jul08

Ah the smell of a fresh install.  Not as good as the smell of a new car but here’s some useful notes.

how to create new user:
[eric@firedragon ~]$ su
Password:
[root@firedragon eric]# su – postgres
-bash-3.2$ createuser –pwprompt
Enter name of role to add: mneme13
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
CREATE ROLE
-bash-3.2$

how to check roles:
connect using psql command line tool as superuser:
-bash-3.2$ psql
postgres=# \du

in my case this gives:
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
———–+———–+————-+———–+————-+———–
mneme13   | no        | no          | yes       | no limit    |
postgres     | yes      | yes        | yes       | no limit    |
(2 rows)

now let’s return to my normal user:
postgres=# \q
-bash-3.2$ su – eric
Password:
[eric@firedragon ~]$

Filed under: Linux   |  2 Comments
Tags: centos, Linux, postgresql