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

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@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 
> <mailto: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.


-- 
Adrian Klaver
adrian.klaver@aklaver.com