Install PostgreSQL2015/01/15

	Install PostgreSQL to configure database server.
[1]	Install PostgreSQL.

[root@www ~]#

yum -y install postgresql-server

[root@www ~]#

/etc/rc.d/init.d/postgresql initdb

Initializing database:

[ OK ]

[root@www ~]#

vi /var/lib/pgsql/data/postgresql.conf

# line 59: uncomment and change (listen all)

listen_addresses = '

# line 33: uncomment and change (change log format)

log_line_prefix = '

%t %u %d

[root@www ~]#

/etc/rc.d/init.d/postgresql start

Starting postgresql service:

[ OK ]

[root@www ~]#

chkconfig postgresql on

[2]	Set admin user's password and add a user.

# switch to postgres user and set password

[root@www ~]#

su - postgres

-bash-4.1$

psql -c "alter user postgres with password 'password'"

ALTER ROLE

# add a user "cent"

-bash-4.1$

createuser cent

Shall the new role be a superuser? (y/n)

# set privileges if you want

[3]	Login with a user just created and make sure basic DB operations.

# create a test DB

[cent@www ~]$

createdb testdb

[cent@www ~]$

psql -l

# confirm

                                  List of databases
   Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileg
es
-----------+----------+----------+-------------+-------------+------------------
-----
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
 testdb    | cent     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)

# connect to the test DB

[cent@www ~]$

psql testdb

psql (8.4.20)
Type "help" for help.

# set password

testdb=#

alter user cent with password 'password';

ALTER ROLE

# create a test table

testdb=#

create table test ( no int,name text );

CREATE TABLE

# insert test data

testdb=#

insert into test (no,name) values (1,'cent');

INSERT 0 1

# confirm

testdb=#

select * from test;

 no | name
----+-------
  1 | cent
(1 row)

# remove test table

testdb=#

drop table test;

DROP TABLE

# quit

testdb=#

# remobe test DB

[cent@www ~]$

dropdb testdb

Matched Content