postgreSQL二進位快速安裝

標籤：postgresql二進位快速安裝

二進位安裝步驟：

groupadd postgres

 useradd -g postgres postgres

 id postgres

 passwd postgres

 mkdir -p /data/postgresql/data 

 mkdir -p /data/postgresql/log

 tar xf postgresql-9.5.9-1-linux-x64-binaries.tar.gz -C /usr/local/

 cd /usr/local/

 chown -R postgres.postgres pgsql

 cd /data

 chown -R postgres.postgres postgresql

 cd /usr/local/pgsql/bin/

 vim /etc/profile

 source /etc/profile

普通使用者啟動postgreSQL服務

 su - postgres

初始化資料庫：

 initdb -E utf8 -D /data/postgresql/data

啟動資料庫：

 pg_ctl -D /data/postgresql/data -l /data/postgresql/log/postgres.log start

[[email protected] log]# tailf /data/postgresql/log/postgres.log 

LOG:  could not create IPv6 socket: Address family not supported by protocol

LOG:  database system was shut down at 2017-10-04 18:06:18 CST

LOG:  MultiXact member wraparound protections are now enabled

LOG:  database system is ready to accept connections

LOG:  autovacuum launcher started

關閉postgresql服務

pg_ctl -D /data/postgresql/data -l /data/postgresql/log/postgres.log stop

[[email protected] log]# tailf /data/postgresql/log/postgres.log 

LOG:  received fast shutdown request

LOG:  aborting any active transactions

LOG:  autovacuum launcher shutting down

LOG:  shutting down

LOG:  database system is shut down

重啟postgresql服務

pg_ctl -D /data/postgresql/data -l /data/postgresql/log/postgres.log restart

[[email protected] log]# tailf /data/postgresql/log/postgres.log 

LOG:  received fast shutdown request

LOG:  aborting any active transactions

LOG:  autovacuum launcher shutting down

LOG:  autovacuum launcher shutting down

LOG:  shutting down

LOG:  database system is shut down

LOG:  could not create IPv6 socket: Address family not supported by protocol

LOG:  database system was shut down at 2017-10-04 18:08:15 CST

LOG:  MultiXact member wraparound protections are now enabled

LOG:  database system is ready to accept connections

LOG:  autovacuum launcher started

查看開機記錄：

 tail -100f /data/postgresql/log/postgres.log

ps -ef

登陸資料庫：

 psql

預設登陸postgresql資料庫是不要求輸入密碼的

本文出自 “10931853” 部落格，請務必保留此出處http://wujianwei.blog.51cto.com/10931853/1970386

postgreSQL二進位快速安裝