Search code examples
herokuheroku-postgresheroku-cli

I am trying to view rows and run queries in my heroku postgres database using the heroku pg:psql command but I always get this error

I am trying to view rows and run queries in my heroku postgres database using the heroku pg:psql command but I always get this error : --> Connecting to postgresql-tapered-69603 psql: error: connection to server at "ec2-52-45-168-55.compute-1.amazonaws.com" (52.45.168.55), port 5432 failed: FATAL: no PostgreSQL user name specified in startup packet connection to server at "ec2-52-45-168-55.compute-1.amazonaws.com" (52.45.168.55), port 5432 failed: FATAL: no PostgreSQL user name specified in startup packet ▸ psql exited with code 2

I have tried using the following commands in iterm but always get an error: heroku pg:psql, heroku pg:psql DATABASE_URL

Solution

  • I just had to update postgresql