Re: Could Not Connect To Server - Mailing list pgsql-general

From Rob Sargent
Subject Re: Could Not Connect To Server
Date
Msg-id a76e9b5a-3354-5fcc-194f-7b3142c811d9@gmail.com
Whole thread Raw
In response to Re: Could Not Connect To Server  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general


On 4/23/20 1: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.
 
Thanks, I appreciate the help.
 
Sent: Thursday, April 23, 2020 at 1:55 PM
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: "Dummy Account" <dummyaccount4u@mail.com>
Cc: "pgsql-general" <pgsql-general@postgresql.org>
Subject: Re: Could Not Connect To Server
On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <dummyaccount4u@mail.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.
 
I take it you're seeing that output in the Terminal shell window.  What value does -D get when you try to start postgres?  Can we see the entire command? The "log" directory will be within the value of -D I believe.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Ned to understand why all the idle connections
Next
From: Adrian Klaver
Date:
Subject: Re: Could Not Connect To Server