Could Not Connect To Server

From: "Dummy Account" <dummyaccount4u(at)mail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Could Not Connect To Server
Date: 2020-04-23 18:18:43
Message-ID: trinity-a1f39fea-ffcd-4e01-943d-0ac58bf7094a-1587665923182@3c-app-mailcom-lxa16
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Hello,</div>

<div>&nbsp;</div>

<div>I am running the following:</div>

<div>MacOS High Sierra 10.13.6</div>

<div>PostgreSQL 12.2</div>

<div>pgAdmin 4</div>

<div>&nbsp;</div>

<div>To see my qustion on Stack Overflow with picture:</div>

<div><a href="https://deref-mail.com/mail/client/0tUk0YweAhY/dereferrer/?redirectUrl=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F61353989%2Fpgadmin-could-not-connect-to-server-connection-refused" target="_blank">https://stackoverflow.com/questions/61353989/pgadmin-could-not-connect-to-server-connection-refused</a></div>

<div>&nbsp;</div>

<div>
<p>I am trying to view databases with pgAdmin. After starting pgAdmin and successfully entering my &quot;master password&quot;. I get the following error while trying to open up the only instance, in this case: &quot;PostgeSQL 12&quot;.</p>

<p>I am getting this pgAdmin error:</p>

<p>&quot;could not connect to server: Connection refused Is the server running on host &quot;localhost&quot; (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host &quot;localhost&quot; (127.0.0.1) and accepting TCP/IP connections on port 5432?&quot;</p>

<p>&nbsp;</p>

<p>Trying to start the server, I navigate too: /Library/PostgreSQL/12/bin</p>

<p>from bin, I ran:&nbsp;sudo -u postgres ./pg_ctl start -D /Library/PostgreSQL/12/data</p>

<pre>pg_ctl: could not start server</pre>

<div>&nbsp;</div>

<div>When I ran the status command instead of start, it of course eluded to not running.</div>

<div>I mention all of this with the caveat that I did recently restore from a backup because I replaced my HDD with a SSD.</div>

<div>&nbsp;</div>

<div>Please advise,</div>

<div>&nbsp;</div>

<div>Thanks</div>
</div>
</div></div></body></html>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-04-23 18:26:08 Re: Could Not Connect To Server
Previous Message Tom Lane 2020-04-23 17:47:48 Re: walreceiver termination