CODEWITHSUNDEEP
postgresqlpsql
Nile Lazarus
Nile Lazarus

Reputation: 48

How to disable/allow SSL for my PEM server installation through Stack Builder?

I installed Postgres v13.11 (x64). After its installation, I opted to install additional services through Stack Builder (PEM Server v9, PEM Agent v9, PEM-HTTPD v2. Stack Builder then started installing PEM Server however when prompted to enter in PEM Server installation details, I get the following error: 'psql: server does not support SSL, but SSL was required'

I've looked at other similar questions and possible solutions online but they all seem to be encountering this error (and subsequently fixing it) while using the psql shell and either setting sslmode to allow or disable as such:

psql "sslmode=disable host=localhost dbname=test"

or

psql "sslmode=allow host=localhost dbname=test"

Im not sure how to use these fixes for an installation through Stack Builder.

Upvotes: 1

Views: 866

Answers (2)

Cynthia Omovoiye
Cynthia Omovoiye

Reputation: 1

This is how I fixed a similar issue for PostgresSQL:

  • Check Services List
  • Press Win + R, type services.msc, and press Enter.
  • Scroll down and look for a service named "PostgreSQL".
  • It will typically be named something like:
    • postgresql-x64-15 or postgresql-x64-17
    • The version number (15, 17, etc.) depends on the installed PostgreSQL version.

Upvotes: 0

Vineeth P A
Vineeth P A

Reputation: 1

Try to use below parameter under pg_hba.conf file:

psql "sslmode=disable host=localhost dbname=test"

Upvotes: 0

Related Questions