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 19:12:31 |
Message-ID: | trinity-8cd0a71f-5141-4035-8782-45d149bc8a0f-1587669151008@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>Hi David,</div>
<div> </div>
<div>When I backed-up, I don't know if the server was offline? I can say that I was not running pgAdmin. For instance, I backed up the Operating System and all of its applications. If I go run other application, including other servers, they work. As a matter of fact, if I boot into the old hard drive while it is outside of the laptop, it still works just as it did before I took it out of the laptop.</div>
<div> </div>
<div>As far as your question of "And the relevant content from the log directory log file?": what are you asking for? That <strong>is</strong> the entire and complete log after that command.</div>
<div> </div>
<div>Thanks, I appreciate the help.</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:55 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:48 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>But here they are:</div>
</div>
</div>
</blockquote>
<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>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".</div>
</div>
</div>
</blockquote>
<div> </div>
<div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;">And the relevant content from the log directory log file?</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> 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>
</div>
</div>
</blockquote>
<div> </div>
<div class="gmail_default" style="font-family: arial , helvetica , sans-serif;">And was that Time Machine backup made while the server was offline? If not, and you didn't take any explicit steps to backup and restore the database itself, then your database may be corrupted and thus unable to boot. The log file should indicate whether that is the case.</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.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2020-04-23 19:23:02 | Re: Could Not Connect To Server |
Previous Message | David G. Johnston | 2020-04-23 18:57:21 | Re: Ned to understand why all the idle connections |