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

From David G. Johnston
Subject Re: Could Not Connect To Server
Date
Msg-id CAKFQuwYaq6zCw=F3soEBQDo1VRzb9e0ZV7AvQVa0W=Yzv8_2KQ@mail.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 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.

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: Re: Ned to understand why all the idle connections
Next
From: "David G. Johnston"
Date:
Subject: Re: Ned to understand why all the idle connections