Quick Links

Fw: Re: Could Not Connect To Server

From:	"Dummy Account" <dummyaccount4u(at)mail(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, adrian(dot)klaver(at)aklaver(dot)com
Subject:	Fw: Re: Could Not Connect To Server
Date:	2020-04-23 20:24:26
Message-ID:	trinity-82585037-9cd4-46b8-905c-1cc12a728eb4-1587673466514@3c-app-mailcom-lxa16
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

<div>
<div>Hey Everyone,</div>

<div>I did find loggin.h and insallation_summary.log.  Neither of which look to include the info you may want.</div>

<div>Please advise as to what log file you want to see.</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:32 PM<br/>
<b>From:</b> "Dummy Account" <dummyaccount4u(at)mail(dot)com><br/>
<b>To:</b> "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com><br/>
<b>Cc:</b> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org><br/>
<b>Subject:</b> Re: Could Not Connect To Server</div>

<div>
<div>Hey David,</div>

<div>Can you tell me the exact name of the log file?  Then I can search for it.</div>

<div>Thanks</div>

<div> 
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);">
<div style="margin: 0 0 10.0px 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>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>
</div>
</div>
</div>
</div></div></body></html>

Attachment	Content-Type	Size
unknown_filename	text/html	5.2 KB

In response to

Re: Could Not Connect To Server at 2020-04-23 19:32:52 from Dummy Account

Responses

Re: Fw: Re: Could Not Connect To Server at 2020-04-23 20:27:14 from Adrian Klaver

Browse pgsql-general by date

	From	Date	Subject
Next Message	Adrian Klaver	2020-04-23 20:27:14	Re: Fw: Re: Could Not Connect To Server
Previous Message	Tom Lane	2020-04-23 20:06:53	Re: walreceiver termination