When I try to add a neon hosted db as a data warehouse in segment.com, I get:
failed to connect to PostgreSQL: pq: Malformed password message: invalid payload
If I deliberately use the wrong password I get instead:
failed to connect to PostgreSQL: pq: Malformed password message: bad encoding
I am able to connect to the database using a normal postgres client
Not sure if this is a neon or segment issue
Hi!
Can you try setting ?sslmode=verify-full when specifying Postgres connection string in segment.com?
It looks like there’s no connection string. Segment has separate Host, Port, Database, User, and Password fields.
To add Neon as a destination in Segment, you can use the Option D connection workaround. For example:
Given this connection string:
postgres://daniel:<password>@ep-morning-sunset-123456.us-east-2.aws.neon.tech/neondb
Format your entry for the password field as follows:
project=ep-morning-sunset-123456;<password>
After the updates,
Format your entry for the password field as follows:
endpoint=<endpoint_id>;<password>
Edit: changes from project= to endpoint=
