BUG #16416: unable to start the server with pg_CTL

On 5 May 2020, at 08:28, PG Bug reporting form <noreply@postgresql.org> wrote:

Any suggestions here will be really helpful- thanks.

The error is quite likely to be the one pg_ctl tells you:

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.

The permissions are probably still not quite right for the user with which you
are trying to start the server.

If you initdb a fresh database you can inspect the permissions being set there
as a point of reference.

cheers ./daniel

Hi,

Don't change the permissions manually as it may break your configuration.
You may stop and start the service by two ways:

1. sudo su - postgres (assuming your database superuser account is
'postgres')
and execute pg_ctl commands:
pg_ctl -D /Library/PostgreSQL/12/data stop
pg_ctl -D /Library/PostgreSQL/12/data start

2.
sudo launchctl unload
/Library/LaunchDaemons/com.edb.launchd.postgresql-12.plist
sudo launchctl load
/Library/LaunchDaemons/com.edb.launchd.postgresql-12.plist

On Tue, May 5, 2020 at 2:03 PM PG Bug reporting form <noreply@postgresql.org>
wrote:

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

--
Sandeep Thakkar