cli: heroku pg:pull stopped working

HI.

This week the heroku pg:pull command stopped working and it returns:

heroku-cli: Pulling postgresql-metric-35199 ---> aposta10_development
pg_dump: error: connection to server at "ec2-54-160-95-35.compute-1.amazonaws.com" (54.160.95.35), port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
connection to server at "ec2-54-160-95-35.compute-1.amazonaws.com" (54.160.95.35), port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
pg_restore: error: could not read from input file: end of file
 ▸    pg_dump errored with 1

I’m using the latest MacOS and it has been working well until this week. If a new credential is required now, where do I have to add it?

I’ll appreciate any help.

Thanks.

About this issue

Original URL
State: closed
Created 7 months ago
Comments: 16 (7 by maintainers)

Most upvoted comments

I had the same issue with PostgreSQL 16.0, doing brew upgrade libpq fixed it. See https://github.com/Homebrew/homebrew-core/issues/155651#issuecomment-1828065418

alexandregaldeano on Dec 11, 2023

Thanks for the update, I hope you’re able to get the problem resolved. I’m going to go ahead and close this issue for now, but please reopen in the future if needed.

k80bowman on Dec 4, 2023

@k80bowman makes sense and sounds good! Thanks for the help.

I’ve got a Fedora Linux computer I use too and thought I’d do some more testing. Theheroku pg:psql command works. I ran all the tests you provided on Heroku CLI v8.7.1 and it’s all working as expected:

psql --version outputs psql (PostgreSQL) 15.4
I can connect to the URL with psql directly

so maybe it’s an issue with psql v14.X on macOS specifically? That’d make sense given the debugging and info.

brettchalupa on Dec 4, 2023

I’m also experiencing this issue.

pg_dump: error: connection to server at "ec2-52-211-232-23.eu-west-1.compute.amazonaws.com" (52.211.232.23), port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
connection to server at "ec2-52-211-232-23.eu-west-1.compute.amazonaws.com" (52.211.232.23), port 5432 failed: FATAL:  no PostgreSQL user name specified in startup packet
pg_dump(82827,0x1e3a99ec0) malloc: double free for ptr 0x13f00c200
pg_dump(82827,0x1e3a99ec0) malloc: *** set a breakpoint in malloc_error_break to debug
pg_restore: error: could not read from input file: end of file
 ▸    pg_restore errored with 1

❯ heroku -v
heroku/8.7.1 darwin-arm64 node-v16.19.0

Mac OS Sonoma 14.1.1

jmarsh24 on Dec 1, 2023