public inbox for [email protected]
help / color / mirror / Atom feedFrom: Michael J. Cosentino <[email protected]>
To: Gerald Cheves <[email protected]>
Cc: Justin <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: Unable to Connect to Server Error Help
Date: Tue, 25 Feb 2020 20:22:08 -0500
Message-ID: <CAJtCDcZDMkbSBwMVhMrhc2TPn6BTez0YYwTPWDgRfCXAMk9XTA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJtCDcZp=uwZ1o0zw2YZgCZ5Z-jejhiW5FTkRKM3mGpAcT2bJg@mail.gmail.com>
<[email protected]>
<CAJtCDcYTOAxMhPXaWLvq77BXZyNyttKCO7tiquFZzgiViWnJAA@mail.gmail.com>
<CALL-XeMgibBtTz=5fhdqi971LUMW9tusT0cZxw5ZBDQbeiKHpw@mail.gmail.com>
<[email protected]>
Gerald, this worked!
thank you so much :) and thank you to everyone who responded, i really
appreciate it!
take care,
mike
On Tue, Feb 25, 2020 at 10:32 AM Gerald Cheves <[email protected]> wrote:
> On 2/25/2020 9:07 AM, Justin wrote:
>
> 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 <
> [email protected]> 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 <[email protected]>
>> 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
>>>
>>> I configured a Mac about seven years ago and I remember that I had to
> edit the .bash_profile with the proper PATH where Postgres was installed
> because the Mac's had a partial installation.
>
> open ~/.bash_profile - to edit in text wrangler
>
> export PATH="/Library/PostgreSQL/9.3/bin:$PATH"
>
> source ~/.bash_profile - to take effect
>
> echo ~/.bash_profile -to see PATH
>
>
> --
> siamo arrivati sani e salvi
>
>
view thread (6+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Unable to Connect to Server Error Help
In-Reply-To: <CAJtCDcZDMkbSBwMVhMrhc2TPn6BTez0YYwTPWDgRfCXAMk9XTA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox