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

[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数据库是不需要密码的


当前名称:postgreSQL二进制快速安装
转载注明:http://kswsj.cn/article/gghhcg.html

其他资讯