|
added run file
|
1 |
### CentOS5 |
| 2 | ||
| 3 |
# Install |
|
| 4 |
yum -y install postgresql-server |
|
| 5 |
yum -y install postgresql |
|
| 6 |
yum -y install postgresql-devel |
|
| 7 |
chkconfig --level 2345 postgresql on |
|
| 8 | ||
| 9 |
# Start server |
|
| 10 |
service postgresql start |
|
| 11 | ||
| 12 |
# Change config file |
|
| 13 |
vi /var/lib/pgsql/data/pg_hba.conf |
|
| 14 |
# "local" is for Unix domain socket connections only |
|
| 15 |
local all all trust |
|
| 16 | ||
|
updated private test
|
17 |
createuser dbix_custom |
|
added run file
|
18 |
# Shall the new role be a superuser? (y/n) -> y |
| 19 | ||
| 20 |
createdb dbix_custom -U dbix_custom |
|
| 21 | ||
| 22 |
# Connect to database |
|
| 23 |
psql -U dbix_custom dbix_custom |
|
| 24 | ||
| 25 |
# Install DBD::pg |
|
| 26 |
cpanm DBD::Pg |
|
| 27 | ||
|
updated private test
|
28 | |
| 29 | ||
| 30 | ||
| 31 |
########### Memo ############## |
|
|
added run file
|
32 | |
| 33 |
# Drop user |
|
| 34 |
dropuser dbix_custom |
|
|
updated private test
|
35 | |
| 36 |
Ctrl + D でデータベースからでることができる。 |
|
| 37 |