溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
二進制安裝步驟：
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
[root@localhost 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
[root@localhost 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
[root@localhost 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數據庫是不需要密碼的
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
