pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16416: unable to start the server with pg_CTL
3+ messages / 3 participants
[nested] [flat]
* BUG #16416: unable to start the server with pg_CTL
@ 2020-05-05 06:28 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 2 replies; 3+ messages in thread
From: PG Bug reporting form @ 2020-05-05 06:28 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: krishmba06@gmail.com
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16416: unable to start the server with pg_CTL
@ 2020-05-05 08:37 Daniel Gustafsson <daniel@yesql.se>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 0 replies; 3+ messages in thread
From: Daniel Gustafsson @ 2020-05-05 08:37 UTC (permalink / raw)
To: krishmba06@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16416: unable to start the server with pg_CTL
@ 2020-05-06 07:45 Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 0 replies; 3+ messages in thread
From: Sandeep Thakkar @ 2020-05-06 07:45 UTC (permalink / raw)
To: krishmba06@gmail.com; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-05-06 07:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-05 06:28 BUG #16416: unable to start the server with pg_CTL PG Bug reporting form <noreply@postgresql.org>
2020-05-05 08:37 ` Daniel Gustafsson <daniel@yesql.se>
2020-05-06 07:45 ` Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
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