首页 > 其他 > 详细

pg配置

时间:2020-04-05 11:31:51      阅读:80      评论:0      收藏:0      [点我收藏+]

 

-bash-4.2$ cd $PGDATA
-bash-4.2$ ls
base              pg_commit_ts   pg_logical    pg_serial     pg_subtrans  pg_wal                postmaster.opts
current_logfiles  pg_dynshmem    pg_multixact  pg_snapshots  pg_tblspc    pg_xact               postmaster.pid
global            pg_hba.conf    pg_notify     pg_stat       pg_twophase  postgresql.auto.conf
log               pg_ident.conf  pg_replslot   pg_stat_tmp   PG_VERSION   postgresql.conf

-bash-4.2$ cp postgresql.conf postgresql.conf.bak
-bash-4.2$ vi postgresql.conf 

listen_addresses = 0.0.0.0

 

-bash-4.2$ cp pg_hba.conf pg_hba.conf.bak
-bash-4.2$ vi pg_hba.conf
host    all             all             0.0.0.0/0               md5

 

-bash-4.2$ /usr/pgsql-12/bin/pg_ctl restart

可查看日志:cd $PGDATA/log


pg配置

原文:https://www.cnblogs.com/connected/p/12635678.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!