| From: | "Dummy Account" <dummyaccount4u(at)mail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Could Not Connect To Server |
| Date: | 2020-04-23 18:48:35 |
| Message-ID: | trinity-feffac82-333a-4ff4-85b1-35842d2ec777-1587667715403@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>
<div>
<div>The logs are listed on the stack overlow link.</div>
<div>But here they are:</div>
<div> </div>
<div>waiting for server to start....2020-04-22 15:57:51.766 CDT [5255] LOG: starting PostgreSQL 12.2 on x86_64-apple-darwin, compiled by Apple LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit<br/>
2020-04-22 15:57:51.766 CDT [5255] LOG: listening on IPv6 address "::", port 5432<br/>
2020-04-22 15:57:51.766 CDT [5255] LOG: listening on IPv4 address "0.0.0.0", port 5432<br/>
2020-04-22 15:57:51.768 CDT [5255] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"<br/>
2020-04-22 15:57:51.782 CDT [5255] LOG: redirecting log output to logging collector process<br/>
2020-04-22 15:57:51.782 CDT [5255] HINT: Future log output will appear in directory "log".<br/>
stopped waiting<br/>
pg_ctl: could not start server</div>
<div> </div>
<div>You might be misunderstanding where I said restore, I did not backup the database, I restored an Operating System because I changed out my hard drive for a solid state drive; therefore, I had to restore my Operating System from Time Machine/(backup).</div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Sent:</b> Thursday, April 23, 2020 at 1:26 PM<br/>
<b>From:</b> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com><br/>
<b>To:</b> "Dummy Account" <dummyaccount4u(at)mail(dot)com><br/>
<b>Cc:</b> "pgsql-general" <pgsql-general(at)postgresql(dot)org><br/>
<b>Subject:</b> Re: Could Not Connect To Server</div>
<div name="quoted-content">
<div>
<div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;"><span style="font-family: Arial , Helvetica , sans-serif;">On Thu, Apr 23, 2020 at 11:18 AM Dummy Account <<a href="mailto:dummyaccount4u(at)mail(dot)com" onclick="parent.window.location.href='mailto:dummyaccount4u(at)mail(dot)com'; return false;" target="_blank">dummyaccount4u(at)mail(dot)com</a>> wrote:</span></div>
</div>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div> </div>
<div>
<p>Trying to start the server, I navigate too: /Library/PostgreSQL/12/bin</p>
<p>from bin, I ran: sudo -u postgres ./pg_ctl start -D /Library/PostgreSQL/12/data</p>
<pre>pg_ctl: could not start server</pre>
<div> </div>
</div>
</div>
</div>
</blockquote>
<div> </div>
<div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;">What do the logs say...</div>
</div>
<div> </div>
<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<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> </div>
</div>
</div>
</div>
</blockquote>
<div> </div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;">You should be very specific as to how you restored your database from backup because there is a good chance this wasn't done properly and you presently have a corrupted database on your hard drive.</div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;"> </div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;">David J.</div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;"> </div>
</div>
</div>
</div>
</div>
</div>
</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 4.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gauthier | 2020-04-23 18:51:52 | Re: Ned to understand why all the idle connections |
| Previous Message | David G. Johnston | 2020-04-23 18:41:29 | Re: Ned to understand why all the idle connections |