From the Finder, I think that is the same a File Explorer on Widows. From Finder, it's locked; I cannot access it. Could I use the command line and change ownership or access privledges? And then get access?
Thanks
Sent: Thursday, April 23, 2020 at 3:27 PM
From: "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>
To: "Dummy Account" <dummyaccount4u@xxxxxxxx>, "pgsql-general" <pgsql-general@xxxxxxxxxxxxxx>, "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Subject: Re: Fw: Re: Could Not Connect To Server
From: "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>
To: "Dummy Account" <dummyaccount4u@xxxxxxxx>, "pgsql-general" <pgsql-general@xxxxxxxxxxxxxx>, "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Subject: Re: Fw: Re: Could Not Connect To Server
On 4/23/20 1:24 PM, Dummy Account wrote:
> Hey Everyone,
> I did find loggin.h and insallation_summary.log. Neither of which look
> to include the info you may want.
> Please advise as to what log file you want to see.
Did you look under:
/Library/PostgreSQL/12/data
directory for sub-directory?:
log/
And under it for log files?
> Thanks
> *Sent:* Thursday, April 23, 2020 at 2:32 PM
> *From:* "Dummy Account" <dummyaccount4u@xxxxxxxx>
> *To:* "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>
> *Cc:* "David G. Johnston" <david.g.johnston@xxxxxxxxx>, "pgsql-general"
> <pgsql-general@xxxxxxxxxxxxxx>
> *Subject:* Re: Could Not Connect To Server
> Hey David,
> Can you tell me the exact name of the log file? Then I can search for it.
> Thanks
> *Sent:* Thursday, April 23, 2020 at 2:25 PM
> *From:* "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>
> *To:* "Dummy Account" <dummyaccount4u@xxxxxxxx>, "David G. Johnston"
> <david.g.johnston@xxxxxxxxx>
> *Cc:* "pgsql-general" <pgsql-general@xxxxxxxxxxxxxx>
> *Subject:* Re: Could Not Connect To Server
> 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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
> Hey Everyone,
> I did find loggin.h and insallation_summary.log. Neither of which look
> to include the info you may want.
> Please advise as to what log file you want to see.
Did you look under:
/Library/PostgreSQL/12/data
directory for sub-directory?:
log/
And under it for log files?
> Thanks
> *Sent:* Thursday, April 23, 2020 at 2:32 PM
> *From:* "Dummy Account" <dummyaccount4u@xxxxxxxx>
> *To:* "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>
> *Cc:* "David G. Johnston" <david.g.johnston@xxxxxxxxx>, "pgsql-general"
> <pgsql-general@xxxxxxxxxxxxxx>
> *Subject:* Re: Could Not Connect To Server
> Hey David,
> Can you tell me the exact name of the log file? Then I can search for it.
> Thanks
> *Sent:* Thursday, April 23, 2020 at 2:25 PM
> *From:* "Adrian Klaver" <adrian.klaver@xxxxxxxxxxx>
> *To:* "Dummy Account" <dummyaccount4u@xxxxxxxx>, "David G. Johnston"
> <david.g.johnston@xxxxxxxxx>
> *Cc:* "pgsql-general" <pgsql-general@xxxxxxxxxxxxxx>
> *Subject:* Re: Could Not Connect To Server
> 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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
