4

PostgreSQL service initdb doesn't work

view full story
linux-howto

http://serverfault.com – 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? (HowTos)

taskli's picture
Submitted by taskli on 01/15/2012 – Made popular on 01/15/2012

Stories similar to PostgreSQL service initdb doesn't work

I installed postgresql 9.2 from "add-apt-repository ppa:pitti/postgresql" using "apt-get install postgresql-9.2"

At the end of the install and every time I try to launch postgresql by using the following command

/etc/init.d/postgresql start

or

service postgresql start

I get this error:

Error: could not exec /usr/lib/postgresql/9.2/bin/pg_ctl /usr/lib/postgresql/9.2/bin/pg_ctl start -D

deltaecho wrote:Try editing /etc/conf.d/postgresql, and uncomment the line for PGROOT="/var/lib/postgres" (although it is listed as having a default value, doing this resolved the issue for me).EDIT: I found that config by looking in the postgesql.service file, which set the option ExecStartPre=/usr/lib/systemd/scripts/postgresql-initdb.  Looking in the corresponding file, I noticed

Thanks. I've reinstalled the package from testing.However i'm still unable to start the postgresql server. this time it goes like this:user@frodo:~$ sudo systemctl start postgresql.service Job failed.

Hello all,

I can't start postgresql and logs are empty. Here is the complete steps I did so far:

I just installed Opensuse 11.2, got it up to date. Then I zypped in postgresql and postgresql-server.

When I first did rcpostgresql start, after a while (a minute or so of waiting) I got a message "could not start server". Bummer.

Hello,

I've recently started to see this error message when I try to use sytemctl to start a service (any service).

Quote:

[root@localhost ~]# systemctl start httpd.service Error: No space left on device ^C [root@localhost ~]# systemctl start postgresql.service Error: No space left on device Job failed.

I am trying to upgrade postgresql from 9.0.4 to 9.2.3 using the directions from the wiki (postgresql page, under "upgrading"), due to systemd causing my connections to be refused on my socket for 9.0.4...# pacman -S postgresql-old-upgrade postgresql-libs :: postgresql-libs is in IgnorePkg/IgnoreGroup. Install anyway?

PostgreSQL secure 2 years 31 weeks ago

Hello, I want to start PostgreSQL to use secure loging. Therefore i want to create a remote secure connection using the hostssl option in pg_hba.conf. However it is claimed that the PostgreSQL server must also be running with the -l (SSL) and -i (TCP/IP) options.

postgres logfile 27 weeks 2 days ago

I have installed postgres on f18 x86_64 with the following packages

rpm -qa | grep postgres postgresql-libs-9.2.2-1.fc18.x86_64 postgresql-server-9.2.2-1.fc18.x86_64 postgresql-9.2.2-1.fc18.x86_64

These are the instructions I could find to setup and start postgres

su - cd /usr/lib64/pgsql su postgres

$ initdb -D /var/lib/pgsql/data $ pg_ctl -D /v

Postgresql fails to start 39 weeks 5 days ago

I have installed postgresql using pacman. And followed the wiki to get started. But, I got stuck at starting the server.