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

2020-04-23 Thread Rob Sargent
hursday, April 23, 2020 at 5:19 PM *From:* "Dummy Account" *To:* "Adrian Klaver" *Cc:* "pgsql-general" , "David G. Johnston" *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

Fw: Re: Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
brary/PostgreSQL/12/data/log/postgresql-2020-04-22_171300.log.     Sent: Thursday, April 23, 2020 at 5:19 PM From: "Dummy Account" To: "Adrian Klaver" Cc: "pgsql-general" , "David G. Johnston" Subject: Re: Fw: Re: Could Not Connect To Server This worked. s

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Rob Sargent
On 4/23/20 4:19 PM, Dummy Account wrote: 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

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
er password". > So even if I did remove the password for "PostgreSQL" server, would I be > able to reset one? > *Sent:* Thursday, April 23, 2020 at 4:26 PM > *From:* "Adrian Klaver" > *To:* "Dummy Account" > *Cc:* "pgsql-general" ,

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread David G. Johnston
On Thu, Apr 23, 2020 at 3:03 PM Dummy Account wrote: > > I cannot login into a postgres role via command line. > > Issue #1. > I have never done it before via command line, so maybe I am doing it > incorrectly. > I have been attempting to go: > > su - postgres > > The "sudo" in Rob's answer wasn'

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Adrian Klaver
PM *From:* "Adrian Klaver" *To:* "Dummy Account" *Cc:* "pgsql-general" , "David G. Johnston" *Subject:* Re: Fw: Re: Could Not Connect To Server On 4/23/20 1:37 PM, Dummy Account wrote: > From the Finder, I think that is the same a File Explorer on

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
at pgAdmin calls the "master password". So even if I did remove the password for "PostgreSQL" server, would I be able to reset one?    Sent: Thursday, April 23, 2020 at 4:26 PM From: "Adrian Klaver" To: "Dummy Account" Cc: "pgsql-general" , "David

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Rob Sargent
On 4/23/20 3:26 PM, Adrian Klaver wrote: On 4/23/20 1:37 PM, Dummy Account wrote:  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 acces

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Adrian Klaver
On 4/23/20 1:37 PM, Dummy Account wrote: 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? Why not from the command line use a text

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
laver" To: "Dummy Account" , "pgsql-general" , "David G. Johnston" 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 > t

Re: Fw: Re: Could Not Connect To Server

2020-04-23 Thread Adrian Klaver
?: log/ And under it for log files? Thanks *Sent:* Thursday, April 23, 2020 at 2:32 PM *From:* "Dummy Account" *To:* "Adrian Klaver" *Cc:* "David G. Johnston" , "pgsql-general" *Subject:* Re: Could Not Connect To Server Hey David, Can you tell me the

Fw: Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
" Cc: "David G. Johnston" , "pgsql-general" 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" To:

Re: Could Not Connect To Server

2020-04-23 Thread Adrian Klaver
On 4/23/20 12:36 PM, Rob Sargent wrote: On 4/23/20 1:32 PM, Dummy Account wrote: Hey David, Can you tell me the exact name of the log file?  Then I can search for it. Thanks Apparently in your case it is called "log".  I don't have version 12, To be clear 'log' is the name of the directory

Re: Could Not Connect To Server

2020-04-23 Thread Rob Sargent
On 4/23/20 1:32 PM, Dummy Account wrote: Hey David, Can you tell me the exact name of the log file?  Then I can search for it. Thanks Apparently in your case it is called "log".  I don't have version 12, but  version 9's start up name "pg_log" and that is the name of the file in the data dir

Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
  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" To: "Dummy Account" , "David G. Johnston" Cc: "pgsql-general" Subject: Re: Could

Re: Could Not Connect To Server

2020-04-23 Thread Adrian Klaver
rsday, April 23, 2020 at 1:55 PM *From:* "David G. Johnston" *To:* "Dummy Account" *Cc:* "pgsql-general" *Subject:* Re: Could Not Connect To Server On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <mailto:dummyaccoun...@mail.com>> wrote: But here they are

Re: Could Not Connect To Server

2020-04-23 Thread Rob Sargent
*is* the entire and complete log after that command. Thanks, I appreciate the help. *Sent:* Thursday, April 23, 2020 at 1:55 PM *From:* "David G. Johnston" *To:* "Dummy Account" *Cc:* "pgsql-general" *Subject:* Re: Could Not Connect To Server On Thu, Apr 23, 2020

Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
er that command.   Thanks, I appreciate the help.   Sent: Thursday, April 23, 2020 at 1:55 PM From: "David G. Johnston" To: "Dummy Account" Cc: "pgsql-general" Subject: Re: Could Not Connect To Server On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <dummyac

Re: Could Not Connect To Server

2020-04-23 Thread David G. Johnston
On Thu, Apr 23, 2020 at 11:48 AM Dummy Account wrote: > But here they are: > > waiting for server to start2020-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

Re: Could Not Connect To Server

2020-04-23 Thread Dummy Account
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).   Sent: Thursday, April 23, 2020 at 1:26 PM From: "David G. Johnston" To: "Dummy Account" Cc: "pgsql-g

Re: Could Not Connect To Server

2020-04-23 Thread David G. Johnston
On Thu, Apr 23, 2020 at 11:18 AM Dummy Account wrote: > > Trying to start the server, I navigate too: /Library/PostgreSQL/12/bin > > from bin, I ran: sudo -u postgres ./pg_ctl start -D > /Library/PostgreSQL/12/data > > pg_ctl: could not start server > > > What do the logs say... When I ran the