Re: Unable to Connect to Server Error Help

From: "Michael J(dot) Cosentino" <mjcosentino(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Unable to Connect to Server Error Help
Date: 2020-02-25 12:32:26
Message-ID: CAJtCDcYTOAxMhPXaWLvq77BXZyNyttKCO7tiquFZzgiViWnJAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Thanks for the feedback!

I tried inputting “localhost” and “127.0.0.1” into pgadmin’s name field for
setting up a new server, but got an error message that read “connection to
the local server has been lost.”

Any help on what I should try next would be appreciated.

mike

On Tue, Feb 25, 2020 at 4:44 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Mon, 2020-02-24 at 22:25 -0500, Michael J. Cosentino wrote:
> > I am on a MacOS, (10.15.3), I am new to SQL in general, and I've
> downloaded both the Postgres.app and pgadmin 4 for the first time - trying
> to learn from a book from the library.
> > When I initially tried to open pgadmin, I got the error "The application
> server could not be contacted."
> >
> > I closed Postgres.app, and restarted pgadmin, and got past that initial
> error, and got pgadmin to load in my browser (Chrome), but there were no
> Servers in the object browser of pgadmin (the pane on
> > the left).
> >
> > I tried to connect a new server, and got the following error message:
> > "unable to connect to server. timeout expired"
> >
> > I tried inputting the server name for the server from Postgres.app, but
> that didn't seem to do anything. It looks like pgadmin is connecting to the
> correct port (5432), but I basically have no clue
> > what i'm doing wrong.
> >
> > attaching some screenshots of what i'm seeing in pg admin.
>
> According to your screen shot, you used "PostgreSQL 12"
> as "host name/address", but that is not the name of the server.
>
> Try with "localhost" or "127.0.0.1" instead.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Justin 2020-02-25 14:07:33 Re: Unable to Connect to Server Error Help
Previous Message Toni Alfirević 2020-02-25 09:49:57 Drop in insert performance after 20ish seconds