pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: krishmba06@gmail.com
Subject: BUG #16416: unable to start the server with pg_CTL
Date: Tue, 05 May 2020 06:28:13 +0000
Message-ID: <16416-9c4b0a9303f4e085@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16416
Logged by:          Radhakrishnan Rajendran
Email address:      krishmba06@gmail.com
PostgreSQL version: 12.2
Operating system:   Mac os
Description:        

I am unable to start the Postgres server and whenever I use pg_ctl I am
getting the following error - can some one help me to fix this. I changed
the folder permissions using CHmod and tried running with Sudo -s also but
still the problem exists.

one error I did was, I deleted the Postmaster.pid when the server was
running- post this I am getting this issue when ever I try to start the
server through pg_ctl and another error when I use the pgadmin.

Any suggestions here will be really helpful- thanks.

Using Macos Shell command :

pg_ctl start -D /Library/PostgreSQL/12/data waiting for server to
start....2020-05-05 11:40:04.838 IST [1216] FATAL: data directory
"/Library/PostgreSQL/12/data" has wrong ownership 2020-05-05 11:40:04.838
IST [1216] HINT: The server must be started by the user that owns the data
directory. stopped waiting pg_ctl: could not start server Examine the log
output.

Using pgadmin the error is as follows :

could not connect to server: Connection refused Is the server running on
host "localhost" (::1) and accepting TCP/IP connections on port 5434? could
not connect to server: Connection refused Is the server running on host
"localhost" (127.0.0.1) and accepting TCP/IP connections on port 5434? 

p.s. : I modified the hba.conf and also the postgres.conf files to allow
connection from the local ip



view thread (3+ messages)  latest in thread

Message-ID: <16416-9c4b0a9303f4e085@postgresql.org>
Permalink:  ../16416-9c4b0a9303f4e085@postgresql.org/
Also on:    postgresql.org/message-id/16416-9c4b0a9303f4e085@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, krishmba06@gmail.com
  Subject: Re: BUG #16416: unable to start the server with pg_CTL
  In-Reply-To: <16416-9c4b0a9303f4e085@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox