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.g.johnston@xxxxxxxxx>
*To:* "Dummy Account" <dummyaccount4u@xxxxxxxx>
*Cc:* "pgsql-general" <pgsql-general@xxxxxxxxxxxxxx>
*Subject:* Re: Could Not Connect To Server
On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <dummyaccount4u@xxxxxxxx
<mailto:dummyaccount4u@xxxxxxxx>> 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.klaver@xxxxxxxxxxx
