PostgreSQL : Install
PostgreSQL : Install
2015/07/23
|
Install PostgreSQL to configure database server.
| |
| [1] | Install and start PostgreSQL. |
[root@dlp ~]#
yum -y install postgresql-server
[root@dlp ~]#
postgresql-setup initdb
Initializing database ... OK
[root@dlp ~]#
vi/var/lib/pgsql/data/postgresql.conf
# line 59: uncomment and change if allow accesses from remote hosts
listen_addresses = '
*
'
# line 395: uncomment and change if change log format
# the exmaple below is [Date User DB ***] format
log_line_prefix = '
%t %u %d
'
systemctl start postgresql
[root@dlp ~]#
systemctl enable postgresql
|
| [2] | Set PostgreSQL admin user's password and add a user and also add a test database. |
# set password
[root@dlp ~]#
su - postgres
-bash-4.2$
psql -c "alter user postgres with password 'password'"
ALTER ROLE
# add DB user "cent"
-bash-4.2$
createuser cent
# add test database (owner is just the user above)
-bash-4.2$
createdb testdb -O cent
|
| [3] | Login as a user just added above and operate DataBase as test. |
# show Databases
[cent@dlp ~]$
psql -l
List of databases
Name | Owner | Encoding | Collate | 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 test DB
[cent@dlp ~]$
psql testdb
psql (9.2.13)
Type "help" for help.
# set password
testdb=#
alter user cent with password 'password';
ALTER ROLE
# create 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
# show tables
testdb=#
select * from test;
no | name ----+------- 1 | cent (1 row)
# delete test table
testdb=#
drop table test;
DROP TABLE
# quit
testdb=#
\q
# delete test DB
[cent@dlp ~]$
dropdb testdb
|
Comentários
Postar um comentário