[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Fw: Re: Re: Could Not Connect To Server
From: Rob Sargent <robjsargent () gmail ! com>
Date: 2020-04-23 22:55:42
Message-ID: 6d01b41b-2e94-9548-5409-cfb7e80d77a5 () gmail ! com
[Download RAW message or body]
On 4/23/20 4:46 PM, Dummy Account wrote:
> I cd'd into log and listed the files. There are many.
> How should I get the log that you want.
> I tried:
>
> open -a TextEdit postgresql-2020-04-22_171300.log
>
> I got:
>
> LSOpenURLsWithRole() failed for the application
> /Applications/TextEdit.app with error -610 for the file
> /Library/PostgreSQL/12/data/log/postgresql-2020-04-22_171300.log.
>
That appears to me to say that, for the current user, TextEdit could not
open the log file. What was the effective user? Were you still in a
session under 'sudo su - postgres' in which case postgres can't read the
log file. If that's the case then postgres likely can't read the data
files either.
Can you show the output of these commands in the data directory?
id
\ls -ltr
I ask for the "\ls" to make sure there are no funny aliases in place.
> *Sent:* Thursday, April 23, 2020 at 5:19 PM
> *From:* "Dummy Account" <dummyaccount4u@mail.com>
> *To:* "Adrian Klaver" <adrian.klaver@aklaver.com>
> *Cc:* "pgsql-general" <pgsql-general@postgresql.org>, "David G.
> Johnston" <david.g.johnston@gmail.com>
> *Subject:* Re: Fw: Re: Could Not Connect To Server
> This worked.
> sudo su - postgres
> I was now able to log into data and ls
> Inside data is "log".
> How do I open log?
> and got:
> LSOpenURLsWithRole() failed with erro -610
> I then tried:
> log show
> and I got:
> log: Could not be open local log store: The log archive format is
> corrupt and cannot be read
> So that right there sounds more conducive to the OS being restored(
> not that I know ), all the files were likely rewritten?
>
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
<br>
<div class="moz-cite-prefix">On 4/23/20 4:46 PM, Dummy Account
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:trinity-495be6d4-506d-4787-b389-ebcf1bdea073-1587681966539@3c-app-mailcom-lxa16">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div style="font-family: Verdana;font-size: 12.0px;">
<div> </div>
<div>
<div>I cd'd into log and listed the files. There are many.</div>
<div>How should I get the log that you want.</div>
<div> </div>
<div> </div>
<div>I tried:</div>
<div>
<p>open -a TextEdit postgresql-2020-04-22_171300.log</p>
<p>I got:</p>
<p>LSOpenURLsWithRole() failed for the application
/Applications/TextEdit.app with error -610 for the file
/Library/PostgreSQL/12/data/log/postgresql-2020-04-22_171300.log.</p>
</div>
<div> </div>
</div>
</div>
</blockquote>
That appears to me to say that, for the current user, TextEdit could
not open the log file. What was the effective user? Were you still
in a session under 'sudo su - postgres' in which case postgres can't
read the log file. If that's the case then postgres likely can't
read the data files either.<br>
<br>
Can you show the output of these commands in the data directory?<br>
<blockquote>id<br>
\ls -ltr<br>
</blockquote>
I ask for the "\ls" to make sure there are no funny aliases in
place.<br>
<br>
<blockquote type="cite"
cite="mid:trinity-495be6d4-506d-4787-b389-ebcf1bdea073-1587681966539@3c-app-mailcom-lxa16">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding:
10px 0 10px 10px; border-left:2px solid #C3D9E5;
word-wrap: break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Sent:</b> Thursday,
April 23, 2020 at 5:19 PM<br>
<b>From:</b> "Dummy Account"
<a class="moz-txt-link-rfc2396E" \
href="mailto:dummyaccount4u@mail.com"><dummyaccount4u@mail.com></a><br> \
<b>To:</b> "Adrian Klaver"
<a class="moz-txt-link-rfc2396E" \
href="mailto:adrian.klaver@aklaver.com"><adrian.klaver@aklaver.com></a><br> \
<b>Cc:</b> "pgsql-general"
<a class="moz-txt-link-rfc2396E" \
href="mailto:pgsql-general@postgresql.org"><pgsql-general@postgresql.org></a>, \
"David G.
Johnston" <a class="moz-txt-link-rfc2396E" \
href="mailto:david.g.johnston@gmail.com"><david.g.johnston@gmail.com></a><br>
<b>Subject:</b> Re: Fw: Re: Could Not Connect To Server</div>
<div name="quoted-content">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>This worked.</div>
<div>
<div>sudo su - postgres</div>
<div>I was now able to log into data and ls</div>
<div>Inside data is "log".</div>
<div> </div>
<div>How do I open log?</div>
<div>and got:</div>
<div>LSOpenURLsWithRole() failed with erro -610</div>
<div>
<div> </div>
<div>I then tried:</div>
<div>log show</div>
<div>and I got:</div>
<div>log: Could not be open local log store: The
log archive format is corrupt and cannot be read</div>
<div> </div>
<div>So that right there sounds more conducive
to the OS being restored( not that I know ), all
the files were likely rewritten?</div>
<div> </div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic