New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
No pg_hba.conf for host #72
Comments
Have you tried this? Let me know if it works. |
Closing. No response. |
I am facing same issue while connecting to aws redshift |
@mtxr I understand I need to make a change in |
I'm facing the same situation. I tried to add the pgOptions to my settings (see #547 ) but can't find the json. |
To connect to AWS RDS, I need to set this TWO:
The {
"pgOptions": {
"ssl": {
"requestCert": true,
"rejectUnauthorized": false
}
},
"previewLimit": 50,
"server": "XXX",
"port": 5432,
"driver": "PostgreSQL",
"name": "aws.rds.starter",
"username": "XXX",
"database": "XXX"
} |
Issue Type
Prerequisites (For bugfixes)
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)
Connect to database and receive message "currently connected"
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
You can get this information from executing
SQLTools: Version
from VSCodeQuick Open
.The text was updated successfully, but these errors were encountered: