No pg_hba.conf for host

[brbarkley]

Issue Type

• Feature Request
• Bugfix/Errors
• Questions
• Other

Prerequisites (For bugfixes)

• Are you running the latest version?
• Did you check the logs?
• Did you check the Setup?

Description

Received error message: "no pg_hba.conf entry for host..." when trying to connect to postgresql database using SQLTools. I can connect on same computer from command line using psql and via python using psycopg2. Do you know what the problem might be?

Steps to Reproduce (For bugfixes)

1. Entered sqltools.connections settings

2. Connect to database and receive message "currently connected"

3. Used SQLToolsConnection: Run Query

Expected behavior: [What you expected to happen]
Expected to retrieve data from database

Actual behavior: [What actually happened]
Received error message: "no pg_hba.conf entry for host..."

Versions

• Version: SQLTools v0.12.1
• OS: Windows 10
• SGDB: PostgresSQL

You can get this information from executing SQLTools: Version from VSCode Quick Open.

[mtxr]

Have you tried this?

https://dba.stackexchange.com/questions/83984/connect-to-postgresql-server-fatal-no-pg-hba-conf-entry-for-host

Let me know if it works.

[mtxr]

Closing. No response.

[fatangare]

I am facing same issue while connecting to aws redshift

[sabahang]

@mtxr I understand I need to make a change in postgresql.conf but where is this file? my postgres is on a cloud server and everyone else can connect to it. I'm not running it locally nor have access to it's config

[holgerzer]

@mtxr I understand I need to make a change in postgresql.conf but where is this file? my postgres is on a cloud server and everyone else can connect to it. I'm not running it locally nor have access to it's config

I'm facing the same situation. I tried to add the pgOptions to my settings (see #547 ) but can't find the json.

[Vorobeyko]

i fixed problem with following step

1. Enabled ssl
2. check requestCert

[jqknono]

To connect to AWS RDS, I need to set this TWO:

• SSL: Enabled
• rejectUnauthorized: Check And Uncheck. This is important, and make a difference.

The "rejectUnauthorized": false should fill in the setting explicitly.

{
  "pgOptions": {
    "ssl": {
      "requestCert": true,
      "rejectUnauthorized": false
    }
  },
  "previewLimit": 50,
  "server": "XXX",
  "port": 5432,
  "driver": "PostgreSQL",
  "name": "aws.rds.starter",
  "username": "XXX",
  "database": "XXX"
}