supabase / realtime

Broadcast, Presence, and Postgres Changes via WebSockets
https://supabase.com/realtime
Apache License 2.0
6.82k stars 315 forks source link

invalid_authorization_specification when connecting to postgres database #590

Open pieveee opened 1 year ago

pieveee commented 1 year ago

Bug report

Describe the bug

Trying to connect to the database results in:

16:53:21.498 [error] Postgrex.Protocol (#PID<0.137.0>) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) pg_hba.conf rejects connection for host "192.168.251.150", user "postgres", database "postgres", no encryption

Expected behavior

It should be possible to adjust postgres connection parameters for the docker container. But they don't seem to be documented. Before I invest too much time in reverse engineering the code base I am looking for some help.

PS: I am working on improvements to bring our Kubernetes edition of supabase into a stable state. So help is appreciated. :)

filipecabaco commented 1 year ago

Hi @pieveee

Can you provide more information about your postgres database setup?

usamahzaheer commented 8 months ago

@pieveee hey i'm getting this issue too, have this been resolved, just checking?