Comments (16)
I had the same issue with PostgreSQL 16.0, doing brew upgrade libpq
fixed it. See Homebrew/homebrew-core#155651 (comment)
from heroku-cli.
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
from heroku-cli.
@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
outputspsql (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.
from heroku-cli.
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.
from heroku-cli.
@celsoMartins this seems like more of an account problem rather than a CLI problem. I would recommend reaching out to Heroku support.
from heroku-cli.
Ok then.
But I am able to do everything on Heroku's page and I can still connect to heroku pg:backups
Anyway, I'll reach them. Thank you.
from heroku-cli.
I have started to get a similar issue with the pg:psql
command. Here are my details:
$ heroku pg:psql -a MYAPP
--> Connecting to MYAPP-postgresql
psql: error: connection to server at "ec2-ABC123.compute-1.amazonaws.com" (ABC123), port 5432 failed: FATAL: no PostgreSQL user name specified in startup packet
connection to server at "ec2-3-217-62-59.compute-1.amazonaws.com" (ABC123), port 5432 failed: FATAL: no PostgreSQL user name specified in startup packet
▸ psql exited with code 2
and my heroku CLI version:
$ heroku -v
heroku/8.7.1 darwin-x64 node-v16.19.0
I confirmed that my account has access to the app and database and that other heroku
commands work, like heroku run
I'm on MacOS 13.6.1.
from heroku-cli.
Thank you for providing some further information. We'll look into it on our end as well.
from heroku-cli.
I'm working on debugging this, but if a couple of you who are experiencing this issue could answer a few questions for me, I would appreciate it.
- Do you have any environment variables set that start with
PG
orPSQL
? - What version of
psql
do you have installed? - Can you connect directly with
psql $DATABASE_URL
? - If you install a previous version of the Heroku CLI (
heroku update --version 8.7.0
), does this functionality work?
from heroku-cli.
@k80bowman here's some answers to those questions!
- nope, both
env | grep PG
andenv | grep PSQL
return nothing psql --version
outputs:psql (PostgreSQL) 14.10 (Homebrew)
- same error when running
psql postgres://ABC123:[email protected]:5432/0987654321
(changed URL to obscure it)psql: error: connection to server at "ec2-ZXY123.compute-1.amazonaws.com" (SOMEIP), port 5432 failed: FATAL: no PostgreSQL user name specified in startup packet connection to server at "ec2-ZXY123.compute-1.amazonaws.com" (SOMEIP), port 5432 failed: FATAL: no PostgreSQL user name specified in startup packet psql(8711,0x7ff84d4bd700) malloc: *** error for object 0xe3: pointer being freed was not allocated psql(8711,0x7ff84d4bd700) malloc: *** set a breakpoint in malloc_error_break to debug Abort trap: 6
- nope, same issue on version 8.7.0
Let me know if I can do any other testing or debugging! I've installed postresql through Homebrew on my machine.
from heroku-cli.
@brettchalupa thank you, that is very helpful!
from heroku-cli.
@brettchalupa I've discussed this with some other folks here and, especially given that you are seeing the same error when using the psql
command directly, I don't believe that this is a CLI issue. I would recommend reaching out to Heroku Support, they may have seen this issue before and could help you better.
from heroku-cli.
Having the same issue here 👋
macOS Monterey 12.2.1
▶ psql -V
psql (PostgreSQL) 14.9 (Homebrew)
from heroku-cli.
I'm also having this issue -- let me know if I can provide any other information that might be helpful.
macOS Ventura 13.4
>> psql -V
psql (PostgreSQL) 14.9 (Homebrew)
>> heroku --version
heroku/8.5.0 darwin-arm64 node-v16.19.0
from heroku-cli.
@alessandrostein and @bryanwoods, we've had some internal folks run into this problem when they used Homebrew to install postgreSQL, which it looks like you have as well. We recommend following the instructions for installing it without Homebrew, hopefully doing that will resolve the issues you are seeing.
from heroku-cli.
I had the same issue with PostgreSQL 16.0, doing
brew upgrade libpq
fixed it. See Homebrew/homebrew-core#155651 (comment)
For others facing the same issue on MacOS, I can confirm this solved my issue as well :-) Thanks @alexandregaldeano
from heroku-cli.
Related Issues (20)
- plugin-mtls is not installing using heroku cli HOT 4
- Heroku login -- unable to verify the first certificate HOT 12
- Release Key Expired? HOT 13
- Broken autocomplete when installing CLI with homebrew on Linux HOT 4
- Syntax coloration is disabled HOT 7
- node 16 EOL ended 7 months and 3 weeks ago HOT 4
- `heroku commands --json` yields MODULE_NOT_FOUND HOT 1
- i have an issue with heroku login HOT 1
- ERR_UNESCAPED_CHARACTERS: Request path contains unescaped characters HOT 1
- Windows - Add `DisplayVersion` key to registry HOT 6
- Windows - Add DisplayVersion key to registry HOT 1
- Breaking Change for `heroku container:push --recursive` on 9.0.0 HOT 1
- heroku container:release no longer allows migration from heroku-xx stacks since 9.0.0 HOT 2
- CLI v9: breaking regression for pg:backups:schedule when passing in timezone HOT 2
- `heroku run` command arguments are incorrectly sorted, breaking command functionality HOT 11
- heroku/cli docker image not found HOT 1
- Broken build while using older version of docker HOT 1
- <!--
- Heroku/CLI
- Cli
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from heroku-cli.