lapis icon indicating copy to clipboard operation
lapis copied to clipboard

How to postgresql + ssl

Open gitrus opened this issue 6 years ago • 1 comments

How i can set up connect to postgresql with standart ssl? Standart settings cause error: FATAL: no pg_hba.conf entry for host "10.253.1.15", user "tvPlanning", database "emmaTvData", SSL off

I try to resolve my problem by add pg_moon property ssl=true but it doesn't work. ngx.socket connect: expecting 1 ~ 5 arguments (including the object), but seen 6

gitrus avatar Aug 03 '17 11:08 gitrus

The first error sounds to me like a problem with your postgres configuration. I'm not much of an expert when it comes to PG, but I remember having a similar problem and it was about having to allow to connect a certain user in a certain way in the pg_hba.conf, which also appears in your error message. Start by checking the documentation and hopefully that will solve your problem.

Again, I'm not that good with PG, so I'm sorry if this answer is completely unhelpful.

DarkWiiPlayer avatar Mar 29 '18 05:03 DarkWiiPlayer