Re: Fw: Re: Could Not Connect To Server
От | Adrian Klaver |
---|---|
Тема | Re: Fw: Re: Could Not Connect To Server |
Дата | |
Msg-id | 7b6777a3-770d-3d5b-4cdb-2d9c141efc9c@aklaver.com обсуждение исходный текст |
Ответ на | Re: Could Not Connect To Server ("David G. Johnston" <david.g.johnston@gmail.com>) |
Список | pgsql-general |
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@mail.com> > *To:* "Adrian Klaver" <adrian.klaver@aklaver.com> > *Cc:* "David G. Johnston" <david.g.johnston@gmail.com>, "pgsql-general" > <pgsql-general@postgresql.org> > *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@aklaver.com> > *To:* "Dummy Account" <dummyaccount4u@mail.com>, "David G. Johnston" > <david.g.johnston@gmail.com> > *Cc:* "pgsql-general" <pgsql-general@postgresql.org> > *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@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 -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления:
Следующее
От: "David G. Johnston"Дата:
Сообщение: Re: Question on banner display after PG initial connection