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(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.
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.