• Support
  • Unable to connect to PostgreSQL server

I have created a database in postgreSQL through the control panel and when I try to connect to it with the Adminer tool it gives me the following error
Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "dbuser@opalx.opalstack.com", database "postgres", SSL off

thanks in advance for the help

  • sean replied to this.

    clauramial it can take a minute or two for a new database and user to become active on your web server.

    If you're still unable to connect then please contact support via email with the details. Thanks!

    10 months later

    I have exactly the same problem. It's been hours. I've emailed support, but apparently all I can do is wait. Any other suggestions?

    If both your database and database user are marked as "Ready" then you probably don't have the user mentioned defined as a readwrite or readonly user on the database. Once you set one of them you should be able to log in.

      I had the same issue and it was not immediately obvious what I was doing wrong.

      When you create or edit a database, make sure you have actually selected a user from the list of "Read/Write" and/or "Read Only" users. The UI will show you a list of users, that is not the list of users with access. That is the list of user you can select from to grant access.

      The main database page will show which users have access to each database directly to the right of the database name field. If there are no user's listed in those fields, you'll have to click the edit (pencil) icon and select a user from the list.

      Thanks all - yes this indeed turned out to be a case where user wasn't selected as a readwrite or a readonly user for the database - thanks klynton - much appreciated!

      Mastodon