PostgreSQL安装日志
时间：2021-07-01 10:21:17
帮助过：9人阅读
databases]
testdb= host=127.0.0.1 port=5432 pool_size=50 dbname=
testdb
[pgbouncer]
pool_mode =
transaction
listen_port = 6543
listen_addr = 0.0.0.0
auth_type =
md5
auth_file =
/home/postgres/pgbouncer/etc/users.txt
logfile =
/home/postgres/pgbouncer/log/pgbouncer.log
pidfile =
/home/postgres/pgbouncer/pgbouncer.pid
unix_socket_dir =
/home/postgres/pgbouncer/etc
admin_users =
pgadmin
stats_users =
pgstat
server_reset_query =
DISCARD ALL
server_check_query = select 1
server_check_delay = 30
max_client_conn = 50000
default_pool_size = 20
reserve_pool_size = 5
dns_max_ttl = 15
ignore_startup_parameters = extra_float_digits
vim users.txt
postgres用户密码为postgres
"postgres" "md53175bce1d3201d16594cebf9d7eb3f9d"
"pgadmin" "pgadmin"
"pgstat" "md510a90e7529bc649302c9bfabefd51b93"
第三步：安装本地告诉缓存pgfincore(请自行去网上下载)
下载好文件后，解压
make&&make install 即可
至此，pg服务安装完成，而且还有一个相当好的性能哦！
PostgreSQL安装日志
标签：
