PostgreSQL service initdb doesn’t work

databasepostgresql

I installed PostgreSQL 9.1.2 on my fedora 16 in a method similar to mentioned here, and tested it, which means that my installation is working fine.

But when I do: service postgresql initdb or even service postgresql-9.0 initdb I get the error:

Redirecting to /bin/systemctl  initdb postgresql.service
Unknown operation initdb

And because of this, I am unable to start pgAdmin3 too.

What am I missing?

Best Answer

On systems where postgres has been converted to use a native systemd unit you need to use postgresql-setup for things like initdb. So what you want is:

postgresql-setup initdb

Related Solutions

Postgresql – What do I do when pg_cancel_backend doesn’t work

http://www.postgresql.org/docs/current/static/server-shutdown.html

pg_cancel_backend is equivalent to sending SIGINT to the process.
pg_terminate_backend likewise for SIGTERM, but if pg_cancel_backend isn't working I don't see why pg_terminate_backend would.

If you've tried those options, you could try SIGQUIT. The docs say, "This is recommended only in emergencies."

(If you hate your data and hope it dies, you could use SIGKILL. But I wouldn't.)

You can use either kill directly or pg_ctl kill.

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

OK, got it from someone else. This query should do the trick:

select *
from pg_stat_activity
where datname = 'mydatabasename';

Best Answer

Related Solutions

Postgresql – What do I do when pg_cancel_backend doesn’t work

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

Related Topic