cli icon indicating copy to clipboard operation
cli copied to clipboard

failed to connect to postgres: failed to connect to `host=127.0.0.1 user=postgres database=postgres`: failed to receive message (read tcp 127.0.0.1:34868->127.0.0.1:54320: read: connection reset by peer)

Open pmnzt opened this issue 1 year ago • 0 comments

Just trying out supabase migration squash for the first time and got: failed to connect to postgres: failed to connect to `host=127.0.0.1 user=postgres database=postgres`: failed to receive message (read tcp 127.0.0.1:34868->127.0.0.1:54320: read: connection reset by peer)

I did also try supabase migration squash with --db-url passing the local db url, did not work, i tried too --local. did not work.

All i am trying to do is squash the local migrations.

Cli version: 1.150.0 OS: debian 12 bookworm

Wanna see the command with --debug?

Here you go:

2024/03/21 00:59:24 Connect Start: tcp 127.0.0.1:54320
2024/03/21 00:59:24 Connect Done: tcp 127.0.0.1:54320
2024/03/21 00:59:24 PG Send: {"Type":"StartupMessage","ProtocolVersion":196608,"Parameters":{"database":"postgres","user":"postgres"}}

The result ?

failed to connect to postgres: failed to connect to `host=127.0.0.1 user=postgres database=postgres`: dial error (timeout: dial tcp 127.0.0.1:54320: i/o timeout)

PS: other commands work fine like migration list, migration new, db diff, db reset.

pmnzt avatar Mar 20 '24 22:03 pmnzt