Error moving data from .json file to Postgres

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Error message when trying to move data from a .json file to Postgres using the airbyte/destination-postgres connector.


Question

Hi Guys,
I want to move data from the .json file to postgress using this command.
cat secrets/test.json | docker run --rm --init -i -v $(pwd)/secrets:/secrets --network secrets_airbyte airbyte/destination-postgres write --config /secrets/db.json --catalog /secrets/configured_catalog.json

db.json has configuration:

  "host": "",
  "port": 5432,
  "database": "",
  "schema": "",
  "username": "",
  "password": "",
  "ssl": true
}```
I am getting this error:

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1704811520850379) if you want to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["json-file", "postgres", "airbyte-connector", "error"]
</sub>