Advertisement
Guest User

Untitled

a guest
Aug 15th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. hostssl all all ###.###.###.###/32 md5
  2.  
  3. psql: ERROR: no pg_hba.conf entry for host "XXX.XXX.XXX.XXX", user "myuser", database "mydb", SSL off
  4.  
  5. [databases]
  6. my_database = host=xxx.xxx.xxx.xxxx port=5432 dbname=mydb user=myuser password=mypassword client_encoding='UTF8'
  7.  
  8. [pgbouncer]
  9. listen_addr = *
  10. listen_port = 5432
  11. auth_type = md5
  12.  
  13. auth_file = /etc/pgbouncer/userlist.txt
  14. logfile = /var/log/postgresql/pgbouncer.log
  15. pidfile = /var/run/postgresql/pgbouncer.pid
  16.  
  17. admin_users = rms_admin
  18.  
  19. pool_mode = session
  20.  
  21. server_reset_query = DISCARD ALL
  22. server_check_query = select 1
  23.  
  24. default_pool_size = 40
  25.  
  26. stats_period=300
  27.  
  28. log_pooler_errors = 1
  29.  
  30. ERROR skipping database my_database because of unknown parameter in connstring: sslmode
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement