티스토리 뷰

CentOS 5 PostgreSQL Install PostgreSQL


Install PostgreSQL

  Install PostgreSQL for database server.


[root@www ~]# yum -y install postgresql-server


[root@www ~]# vi /var/lib/pgsql/data/postgresql.conf

# line 49: uncomment and change (listen all)

listen_addresses = '*'


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

log_line_prefix = '%t %u %d'


[root@www ~]# /etc/rc.d/init.d/postgresql start 

Initializing database: [ OK ]

Starting postgresql service: [ OK ]


[root@www ~]# chkconfig postgresql on


[root@www ~]# su - postgres # switch to the postgres user

# set password for postgres user

-bash-3.2$ psql -c "alter user postgres with password 'password'" 

ALTER ROLE

-bash-3.2$ createuser cent # create a DB user "cent"

Shall the new role be a superuser? (y/n) y# set privilege if you want

CREATE ROLE

-bash-3.2$ su - cent # switch to the "cent" user on OS

Password:


[cent@www ~]$ createdb testdb # create a test DB

CREATE DATABASE


[cent@www ~]$ psql -l # show DB

        List of databases

   Name    |  Owner   | Encoding

-----------+----------+----------

 postgres  | postgres | UTF8

 template0 | postgres | UTF8

 template1 | postgres | UTF8

 testdb    | cent     | UTF8

(4 rows)


[cent@www ~]$ psql testdb # connect to the test DB

Welcome to psql 8.1.23, the PostgreSQL interactive terminal.


Type:  \copyright for distribution terms

       \h for help with SQL commands

       \? for help with psql commands

       \g or terminate with semicolon to execute query

       \q to quit



# 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=# \q


[cent@www ~]$ dropdb testdb # remove test DB


※ Next manual



저작자 표시 비영리 변경 금지
신고

'EN > CentOS 5' 카테고리의 다른 글

CentOS 5 Install MySQL  (0) 2016.06.10
CentOS 5 PostgreSQL Install PostgreSQL  (0) 2016.06.10
CentOS 5 Install WordPress  (0) 2016.06.09
CentOS 5 WebMail - RoundCube  (0) 2016.06.09
CentOS 5 WebMail - SquirrelMail  (0) 2016.06.09
CentOS 5 Apache Web Site Access Analyzer - Piwik  (0) 2016.06.08
댓글