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

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

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

<div>&nbsp;</div>

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

<div>&nbsp;</div>

<div>Please advise as to what log file you want to see.</div>

<div>&nbsp;</div>

<div>Thanks</div>

<div>&nbsp;
<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>&nbsp;Thursday, April 23, 2020 at 2:32 PM<br/>
<b>From:</b>&nbsp;&quot;Dummy Account&quot; &lt;dummyaccount4u(at)mail(dot)com&gt;<br/>
<b>To:</b>&nbsp;&quot;Adrian Klaver&quot; &lt;adrian(dot)klaver(at)aklaver(dot)com&gt;<br/>
<b>Cc:</b>&nbsp;&quot;David G. Johnston&quot; &lt;david(dot)g(dot)johnston(at)gmail(dot)com&gt;, &quot;pgsql-general&quot; &lt;pgsql-general(at)postgresql(dot)org&gt;<br/>
<b>Subject:</b>&nbsp;Re: Could Not Connect To Server</div>

<div name="quoted-content">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>&nbsp;</div>

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

<div>&nbsp;</div>

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

<div>&nbsp;</div>

<div>Thanks</div>

<div>&nbsp;
<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>&nbsp;Thursday, April 23, 2020 at 2:25 PM<br/>
<b>From:</b>&nbsp;&quot;Adrian Klaver&quot; &lt;adrian(dot)klaver(at)aklaver(dot)com&gt;<br/>
<b>To:</b>&nbsp;&quot;Dummy Account&quot; &lt;dummyaccount4u(at)mail(dot)com&gt;, &quot;David G. Johnston&quot; &lt;david(dot)g(dot)johnston(at)gmail(dot)com&gt;<br/>
<b>Cc:</b>&nbsp;&quot;pgsql-general&quot; &lt;pgsql-general(at)postgresql(dot)org&gt;<br/>
<b>Subject:</b>&nbsp;Re: Could Not Connect To Server</div>

<div>On 4/23/20 12:12 PM, Dummy Account wrote:<br/>
&gt; Hi David,<br/>
&gt; When I backed-up, I don&#39;t know if the server was offline? &nbsp;I can say<br/>
&gt; that I was not&nbsp;running pgAdmin. &nbsp;For instance, I backed up the Operating<br/>
&gt; System and all of its applications. &nbsp;If I go run other application,<br/>
&gt; including other servers, they work. &nbsp;As a matter of fact, if I boot into<br/>
&gt; the old hard drive while&nbsp;it is outside of the laptop, it still works<br/>
&gt; just as it did before I took it out of the laptop.<br/>
&gt; As far as your question of &quot;And the relevant content from the log<br/>
&gt; directory log file?&quot;: what are you asking for?&nbsp; That *is* the entire and<br/>
&gt; 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/>
&gt; Thanks, I appreciate the help.<br/>
&gt; *Sent:*&nbsp;Thursday, April 23, 2020 at 1:55 PM<br/>
&gt; *From:*&nbsp;&quot;David G. Johnston&quot; &lt;david(dot)g(dot)johnston(at)gmail(dot)com&gt;<br/>
&gt; *To:*&nbsp;&quot;Dummy Account&quot; &lt;dummyaccount4u(at)mail(dot)com&gt;<br/>
&gt; *Cc:*&nbsp;&quot;pgsql-general&quot; &lt;pgsql-general(at)postgresql(dot)org&gt;<br/>
&gt; *Subject:*&nbsp;Re: Could Not Connect To Server<br/>
&gt; On Thu, Apr 23, 2020 at 11:48 AM Dummy Account &lt;dummyaccount4u(at)mail(dot)com<br/>
&gt; &lt;mailto:dummyaccount4u(at)mail(dot)com&gt;&gt; wrote:<br/>
&gt;<br/>
&gt; But here they are:<br/>
&gt;<br/>
&gt; waiting for server to start....2020-04-22 15:57:51.766 CDT [5255]<br/>
&gt; LOG: &nbsp;starting PostgreSQL 12.2 on x86_64-apple-darwin, compiled by<br/>
&gt; Apple LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit<br/>
&gt; 2020-04-22 15:57:51.766 CDT [5255] LOG: &nbsp;listening on IPv6 address<br/>
&gt; &quot;::&quot;, port 5432<br/>
&gt; 2020-04-22 15:57:51.766 CDT [5255] LOG: &nbsp;listening on IPv4 address<br/>
&gt; &quot;0.0.0.0&quot;, port 5432<br/>
&gt; 2020-04-22 15:57:51.768 CDT [5255] LOG: &nbsp;listening on Unix socket<br/>
&gt; &quot;/tmp/.s.PGSQL.5432&quot;<br/>
&gt; 2020-04-22 15:57:51.782 CDT [5255] LOG: &nbsp;redirecting log output to<br/>
&gt; logging collector process<br/>
&gt; 2020-04-22 15:57:51.782 CDT [5255] HINT: &nbsp;Future log output will<br/>
&gt; appear in directory &quot;log&quot;.<br/>
&gt;<br/>
&gt; And the relevant content from the log directory log file?<br/>
&gt;<br/>
&gt; &nbsp;stopped waiting<br/>
&gt; pg_ctl: could not start server<br/>
&gt; You might be misunderstanding where I said restore, I did&nbsp;not backup<br/>
&gt; the database, I restored an Operating System because I changed out<br/>
&gt; my hard drive for a solid state drive; therefore, I had to restore<br/>
&gt; my Operating System from Time Machine/(backup).<br/>
&gt;<br/>
&gt; And was that Time Machine backup made while the server was offline?&nbsp; If<br/>
&gt; not, and you didn&#39;t take any explicit steps to backup and restore the<br/>
&gt; database itself, then your database may be corrupted and thus unable to<br/>
&gt; boot.&nbsp; The log file should indicate whether that is the case.<br/>
&gt; 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

Responses

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