Re: Could Not Connect To Server

From: "David G(dot) 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
Date: 2020-04-23 18:55:47
Message-ID: CAKFQuwYaq6zCw=F3soEBQDo1VRzb9e0ZV7AvQVa0W=Yzv8_2KQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-04-23 18:57:21 Re: Ned to understand why all the idle connections
Previous Message David Gauthier 2020-04-23 18:51:52 Re: Ned to understand why all the idle connections