Quick Links

Re: Fw: Re: Could Not Connect To Server

From:	"Dummy Account" <dummyaccount4u(at)mail(dot)com>
To:	"Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Cc:	pgsql-general <pgsql-general(at)postgresql(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Subject:	Re: Fw: Re: Could Not Connect To Server
Date:	2020-04-23 20:37:29
Message-ID:	trinity-eb2c7ba8-d1e9-400e-b345-626ae81c0e35-1587674249947@3c-app-mailcom-lxa16
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

<div>
<div>From the Finder, I think that is the same a File Explorer on Widows.  From Finder, it's locked; I cannot access it.  Could I use the command line and change ownership or access privledges?  And then get access?</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;">Sent: Thursday, April 23, 2020 at 3:27 PM 
From: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> 
To: "Dummy Account" <dummyaccount4u(at)mail(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> 
Subject: Re: Fw: Re: Could Not Connect To Server</div>

<div name="quoted-content">On 4/23/20 1:24 PM, Dummy Account wrote: 
> Hey Everyone, 
> I did find loggin.h and insallation_summary.log.  Neither of which look 
> to include the info you may want. 
> Please advise as to what log file you want to see. 
 
Did you look under: 
 
/Library/PostgreSQL/12/data 
 
directory for sub-directory?: 
 
log/ 
 
And under it for log files? 
 
> Thanks 
> *Sent:* Thursday, April 23, 2020 at 2:32 PM 
> *From:* "Dummy Account" <dummyaccount4u(at)mail(dot)com> 
> *To:* "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> 
> *Cc:* "David G. 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 
> Hey David, 
> Can you tell me the exact name of the log file?  Then I can search for it. 
> Thanks 
> *Sent:* Thursday, April 23, 2020 at 2:25 PM 
> *From:* "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> 
> *To:* "Dummy Account" <dummyaccount4u(at)mail(dot)com>, "David G. 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 
> On 4/23/20 12:12 PM, Dummy Account wrote: 
> > Hi David, 
> > 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. 
> > As far as your question of "And the relevant content from the log 
> > directory log file?": what are you asking for?  That *is* the entire and 
> > complete log after that command. 
> 
> Those are the messages sent to the screen. There are also messages sent 
> to the Postgres server log. Not sure where the OS X install puts that, 
> but I would start under /Library/PostgreSQL/12/data. 
> 
> > Thanks, I appreciate the help. 
> > *Sent:* Thursday, April 23, 2020 at 1:55 PM 
> > *From:* "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> 
> > *To:* "Dummy Account" <dummyaccount4u(at)mail(dot)com> 
> > *Cc:* "pgsql-general" <pgsql-general(at)postgresql(dot)org> 
> > *Subject:* Re: Could Not Connect To Server 
> > On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <dummyaccount4u(at)mail(dot)com 
> > <mailto:dummyaccount4u(at)mail(dot)com>> wrote: 
> > 
> > But here they are: 
> > 
> > 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 
> > 2020-04-22 15:57:51.766 CDT [5255] LOG:  listening on IPv6 address 
> > "::", port 5432 
> > 2020-04-22 15:57:51.766 CDT [5255] LOG:  listening on IPv4 address 
> > "0.0.0.0", port 5432 
> > 2020-04-22 15:57:51.768 CDT [5255] LOG:  listening on Unix socket 
> > "/tmp/.s.PGSQL.5432" 
> > 2020-04-22 15:57:51.782 CDT [5255] LOG:  redirecting log output to 
> > logging collector process 
> > 2020-04-22 15:57:51.782 CDT [5255] HINT:  Future log output will 
> > appear in directory "log". 
> > 
> > And the relevant content from the log directory log file? 
> > 
> >  stopped waiting 
> > pg_ctl: could not start server 
> > 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). 
> > 
> > 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. 
> > David J. 
> 
> 
> -- 
> Adrian Klaver 
> adrian(dot)klaver(at)aklaver(dot)com 
 
 
-- 
Adrian Klaver 
adrian(dot)klaver(at)aklaver(dot)com</div>
</div>
</div>
</div></div></body></html>

Attachment	Content-Type	Size
unknown_filename	text/html	6.1 KB

In response to

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

Responses

Re: Fw: Re: Could Not Connect To Server at 2020-04-23 21:26:53 from Adrian Klaver

Browse pgsql-general by date

	From	Date	Subject
Next Message	David G. Johnston	2020-04-23 21:16:12	Re: Question on banner display after PG initial connection
Previous Message	Adrian Klaver	2020-04-23 20:27:14	Re: Fw: Re: Could Not Connect To Server