You are not logged in.

#1 2012-10-29 13:59:18

cool
Member
Registered: 2008-09-12
Posts: 111
Website

PostgreSQL doesn't start

I have installed postgresql using pacman & now it doesn't start. I get "FATAL:  could not create lock file "/run/postgresql/.s.PGSQL.5432.lock": No such file or directory"  full log here:

$ sudo rc.d start postgresql
:: Starting PostgreSQL                                                                                         [BUSY] 
pg_ctl: could not start server
Examine the log output.
                                                                                                                            [FAIL] 
gaurish@home:~/code$ tail /var/log/postgresql.log 
FATAL:  could not create lock file "/run/postgresql/.s.PGSQL.5432.lock": No such file or directory
FATAL:  could not create lock file "/run/postgresql/.s.PGSQL.5432.lock": No such file or directory

Can one suggest few things that I can try, so Postgres starts

Offline

#2 2012-10-29 14:34:32

foutrelis
Developer
From: Athens, Greece
Registered: 2008-07-28
Posts: 705
Website

Re: PostgreSQL doesn't start

Run the following to create the missing directory (i.e. /run/postgresql):

sudo systemd-tmpfiles --create postgresql.conf

Offline

#3 2012-10-31 02:05:50

fredpyo
Member
Registered: 2012-10-31
Posts: 2

Re: PostgreSQL doesn't start

Nice, this was very helpful. Is this missing in the wiki page for postgres?

Offline

#4 2012-10-31 06:41:11

foutrelis
Developer
From: Athens, Greece
Registered: 2008-07-28
Posts: 705
Website

Re: PostgreSQL doesn't start

It's a bug in the package:

https://bugs.archlinux.org/task/32154

Offline

#5 2012-12-03 13:11:10

amatriain
Member
Registered: 2011-06-02
Posts: 50

Re: PostgreSQL doesn't start

@foutrelis Thanks for the workaround!

Offline

Board footer

Powered by FluxBB