【安装】服务器postgresql安装流程

yum install postgresql93-server

service postgresql initdb

service postgresql start

find ./ -name "pg_hba.conf"

vi /var/lib/pgsql/data/pg_hba.conf  local all trust local all 127.0.0.1 trust

service postgresql restart  

su postgres

createdb centerdb

sudo adduser centerhost

su postgres

psql

CREATE USER centerhost WITH PASSWORD 'K1e2n3+C4';

GRANT ALL PRIVILEGES ON DATABASE exampledb to centerhost;

psql -U centerdb -d centerdb -h 127.0.0.1 -p 5432