Search Postgresql Archives

Re: Could Not Connect To Server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 
The logs are listed on the stack overlow link.
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".
 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).
 
Sent: Thursday, April 23, 2020 at 1:26 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:18 AM Dummy Account <dummyaccount4u@xxxxxxxx> 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 status command instead of start, it of course eluded to not running.
I mention all of this with the caveat that I did recently restore from a backup because I replaced my HDD with a SSD.
 
 
You should be very specific as to how you restored your database from backup because there is a good chance this wasn't done properly and you presently have a corrupted database on your hard drive.
 
David J.
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux