Load to PostgreSQL failing

Running snowplow r97 knossos via command:
snowplow-emr-etl-runner run -c config/config.yml -r config/iglu_resolver.json -t config/targets

This postgres.json is the targets folder:
“schema”: “iglu:com.snowplowanalytics.snowplow.storage/postgresql_config/jsonschema/1-1-0”,
“data”: {
“name”: “PostgreSQL enriched events storage”,
“host”: “mydomain.com”,
“database”: “snowplow”,
“port”: 5432,
“sslMode”: “DISABLE”,
“username”: “storageloader”,
“password”: “mypassword”,
“schema”: “atomic”,
“sshTunnel”: null,
“purpose”: “ENRICHED_EVENTS”

I’ve setup PostgreSQL to listen on all addresses and have added host all storageloader md5 to the pg_hba.conf on my remote server.

Error message:
SEVERE: Connection error:
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “”, user “storageloader”, database “snowplow”, SSL off

S3 Log File:

Access Denied


Any advice is appreciated. Thanks in advance!

Hey @starleaf - that error message generally pops up when the database you are connecting to requires SSL. As a first step you could try changing sslMode to REQUIRE instead of DISABLE.

1 Like