PostgreSQL Install Bug?

Carlwill · 2011-02-08 02:44:57

I installed PostgreSQL on my Arch Linux server for a database server I need however I'm having some problems. I don't know if it's a bug with the package or installer but then I find it hard to believe nobody has noticed this on such a popular / commonly used application like PostgreSQL. Below I'm walking you through all my steps to show you I think I'm doing everything right.

Installed fine:

[root@slave ~]# pacman -S postgresql
resolving dependencies...
looking for inter-conflicts...

Targets (1): postgresql-9.0.3-1

Total Download Size:    0.00 MB
Total Installed Size:   23.31 MB

Proceed with installation? [Y/n] Y
checking package integrity...
(1/1) checking for file conflicts                                           [###########################################] 100%
(1/1) installing postgresql

I start the 'postgres' daemon:

[root@slave ~]# /etc/rc.d/postgresql start
:: Starting PostgreSQL                                                                                                 [BUSY] server starting
                                                                                                                      [DONE]

Now I check to make sure the database server is running:

[root@slave ~]# ps -ef | grep -i "postgre" | grep -v "grep"
[root@slave ~]#

So the server isn't running & I check the logs to find:

postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory

And when I check the directory it's complaining about, it's empty...

[root@slave data]# ls -la
total 8
drwx------ 2 postgres postgres 4096 Jan 30 11:28 .
drwx------ 3 postgres postgres 4096 Jan 30 11:38 ..

I've done a reinstall and another install on a completely different Arch Linux machine and the same issue. Anyone have any ideas?

thisllub · 2011-02-08 12:07:21

Try this
http://www.postgresql.org/docs/9.0/inte … uster.html

Read it all.
hint: find the section about initdb.

Carlwill · 2011-02-08 13:13:03

OK thank you. I never had to do this before so it's either something Arch automatically did previously and now has changed or something new with 9.0.

toofishes · 2011-02-08 18:06:51

If you look at the initscript (/etc/rc.d/postgresql), initdb only gets run for you if /var/lib/postgresql/data doesn't already exist. In your case, I have no idea why it exists and is empty, but that is preventing it from being run for you and having all these files placed there automatically.

Carlwill · 2011-02-08 18:09:02

Understood. I will try that this evening and post back my results. Either it will work or it fails. Thanks for the help!

Arch Linux

#1 2011-02-08 02:44:57

PostgreSQL Install Bug?

#2 2011-02-08 12:07:21

Re: PostgreSQL Install Bug?

#3 2011-02-08 13:13:03

Re: PostgreSQL Install Bug?

#4 2011-02-08 18:06:51

Re: PostgreSQL Install Bug?

#5 2011-02-08 18:09:02

Re: PostgreSQL Install Bug?

Board footer