| From: | "Dummy Account" <dummyaccount4u(at)mail(dot)com> |
|---|---|
| To: | "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Could Not Connect To Server |
| Date: | 2020-04-23 19:32:52 |
| Message-ID: | trinity-c92caf44-4098-42df-bf51-b4040cc32c9f-1587670372096@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>Hey David,</div>
<div> </div>
<div>Can you tell me the exact name of the log file? Then I can search for it.</div>
<div> </div>
<div>Thanks</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 2:25 PM<br/>
<b>From:</b> "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com><br/>
<b>To:</b> "Dummy Account" <dummyaccount4u(at)mail(dot)com>, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(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">On 4/23/20 12:12 PM, Dummy Account wrote:<br/>
> Hi David,<br/>
> When I backed-up, I don't know if the server was offline? I can say<br/>
> that I was not running pgAdmin. For instance, I backed up the Operating<br/>
> System and all of its applications. If I go run other application,<br/>
> including other servers, they work. As a matter of fact, if I boot into<br/>
> the old hard drive while it is outside of the laptop, it still works<br/>
> just as it did before I took it out of the laptop.<br/>
> As far as your question of "And the relevant content from the log<br/>
> directory log file?": what are you asking for? That *is* the entire and<br/>
> complete log after that command.<br/>
<br/>
Those are the messages sent to the screen. There are also messages sent<br/>
to the Postgres server log. Not sure where the OS X install puts that,<br/>
but I would start under /Library/PostgreSQL/12/data.<br/>
<br/>
> Thanks, I appreciate the help.<br/>
> *Sent:* Thursday, April 23, 2020 at 1:55 PM<br/>
> *From:* "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com><br/>
> *To:* "Dummy Account" <dummyaccount4u(at)mail(dot)com><br/>
> *Cc:* "pgsql-general" <pgsql-general(at)postgresql(dot)org><br/>
> *Subject:* Re: Could Not Connect To Server<br/>
> On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <dummyaccount4u(at)mail(dot)com<br/>
> <mailto:dummyaccount4u(at)mail(dot)com>> wrote:<br/>
><br/>
> But here they are:<br/>
><br/>
> waiting for server to start....2020-04-22 15:57:51.766 CDT [5255]<br/>
> LOG: starting PostgreSQL 12.2 on x86_64-apple-darwin, compiled by<br/>
> 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<br/>
> "::", port 5432<br/>
> 2020-04-22 15:57:51.766 CDT [5255] LOG: listening on IPv4 address<br/>
> "0.0.0.0", port 5432<br/>
> 2020-04-22 15:57:51.768 CDT [5255] LOG: listening on Unix socket<br/>
> "/tmp/.s.PGSQL.5432"<br/>
> 2020-04-22 15:57:51.782 CDT [5255] LOG: redirecting log output to<br/>
> logging collector process<br/>
> 2020-04-22 15:57:51.782 CDT [5255] HINT: Future log output will<br/>
> appear in directory "log".<br/>
><br/>
> And the relevant content from the log directory log file?<br/>
><br/>
> stopped waiting<br/>
> pg_ctl: could not start server<br/>
> You might be misunderstanding where I said restore, I did not backup<br/>
> the database, I restored an Operating System because I changed out<br/>
> my hard drive for a solid state drive; therefore, I had to restore<br/>
> my Operating System from Time Machine/(backup).<br/>
><br/>
> And was that Time Machine backup made while the server was offline? If<br/>
> not, and you didn't take any explicit steps to backup and restore the<br/>
> database itself, then your database may be corrupted and thus unable to<br/>
> boot. The log file should indicate whether that is the case.<br/>
> David J.<br/>
<br/>
<br/>
--<br/>
Adrian Klaver<br/>
adrian(dot)klaver(at)aklaver(dot)com</div>
</div>
</div>
</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 4.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2020-04-23 19:36:07 | Re: Could Not Connect To Server |
| Previous Message | Lu, Dan | 2020-04-23 19:27:46 | Question on banner display after PG initial connection |