Re: Fw: Re: Re: Could Not Connect To Server

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Fw: Re: Re: Could Not Connect To Server
Дата
Msg-id 6d01b41b-2e94-9548-5409-cfb7e80d77a5@gmail.com
обсуждение исходный текст
Ответ на Re: Could Not Connect To Server  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general


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?
 


В списке pgsql-general по дате отправления:

Предыдущее
От: Si Chen
Дата:
Сообщение: Re: Ned to understand why all the idle connections
Следующее
От: Preethi S
Дата:
Сообщение: Re: Reg: Help to understand the source code