PostgresSQL install/whm/cpanel?!

[2maz]

Hi there,

I need to use Postgres with an application, but do not know how to install it in whm?

Is there anyone that used and installed the server??

I can see Postgres in my cpanel but when i try to ad a database it says:

Database Created
Added the database test. psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


And when i try to set up a user it says:

Account Created
Added admin with the password ******* psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


What have i missed??

I have tried to restart the Postgres server in whm and also tried to install it from whm "Postgres Config", but then I get this:

Setting up Postgres Config...Done
Reloading Postgres...pg_ctl: cannot find /var/lib/pgsql/data/postmaster.pid
Is postmaster running?
Done

Please someone .. HELP .. =)

[QT]

Postgres needs to be configured to use tcp/ip instead of sockets. Sockets won't work because cPanel operates in a chroot environment.

[2maz]

Hi there QT_,


Lucky me that I am such a pro on config linux then .. haha ..

You do not have 1-2-3 manual around .. =)

[QT]

Originally posted by 2maz
Hi there QT_,


Lucky me that I am such a pro on config linux then .. haha ..

You do not have 1-2-3 manual around .. =)

You're right, you are lucky. However, for those
who aren't so lucky....there are a lot of members here on this forum who are more than happy to post a quick how to. =D

[2maz]

Hi there QT_ again,


So let´s hope that some nice soul out there writes it in this thread then, because I have no clue what to do .. =)

[QT]

Have you checked to see if postmaster is even running? If postgres isn't running, it will cause problems in cPanel.

[2maz]

Hi there QT_,

What is postmaster?? (So much for my linux knowledge .. =)

[QT]

Postmaster is the main postgresql process.
To check if it's running type:

ps auxww | grep postmaster

If it's not, to start it you:

service postgresql start

or

service postgres start

(not sure exactly which one it is)

:)

[svi]

Here's what I get when I try to start postgresql:

# service postgresql start
Initializing database: [FAILED]
Starting postgresql service: [FAILED]

But I assume it's installed because postmaster is there:

# postmaster
"root" execution of the PostgreSQL server is not permitted.

The server must be started under an unprivileged user id to prevent
a possible system security compromise. See the documentation for
more information on how to properly start the server.

I've tried installing a new postgres config with WHM, but that didn't help. How can I get it working? :confused:

svi