Re: Unable to Connect to Server Error Help

publish the pg_hba.conf file see if there is a bad configuration going on
in there, and lets see what the SSL setting are for the connection..

https://www.postgresql.org/docs/current/auth-pg-hba-conf.html

On Tue, Feb 25, 2020 at 7:32 AM Michael J. Cosentino <mjcosentino(at)gmail(dot)com>
wrote:

> 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
>>
>>