Postgres (1.9) settings in webmin for Debian?

4 posts / 0 new
Last post
#1 Mon, 06/04/2012 - 14:11
Brook

Postgres (1.9) settings in webmin for Debian?

I've created a Debian 6 VM via virtualbox on my local machine - before taking the plunge on a production server - and do like what I've seen so far. Erasing the old postgres and replacing it with 9.1 was quite elegantly handled - I just erased the old package and used backports to get the latest one :)

However, Virtualmin/webmin is not picking it up. I think I have put all the correct paths in there, but still it says: 'PostgreSQL is not running on your system - database list could not be retrieved.'

Postgres 9.1 is running on the system, just not being picked up by webmin. Here are my settings, do they look ok?

http://i48.tinypic.com/2092hwp.png

Any ideas what I might be doing wrong?

Mon, 06/04/2012 - 15:21
andreychek

Howdy,

Well, it's tough to say, as most distributions aren't using Postgres 9.1... but my suspicion is that it's somehow related to the path to the PID file.

I see from your screenshot that you've updated that, but you may want to triple-check that the "Path to postmaster PID file" option points to a file that exists while Posgres is running.

-Eric

Mon, 06/04/2012 - 15:56
Brook

Hi Eric, thanks for the reply.

That's the only file I get with a find:

$ find / -name postmaster.pid
/var/lib/postgresql/9.1/main/postmaster.pid

If I just enter the file name I get permission denied:

/var/lib/postgresql/9.1/main/postmaster.pid
bash: /var/lib/postgresql/9.1/main/postmaster.pid: Permission denied

Or on opening I get these contents:

18633
/var/lib/postgresql/9.1/main
1338834257
5433
/var/run/postgresql
localhost
5433001 983041

All of the other paths I found via find too. Any other ideas on what it might be? Thanks.

Mon, 06/04/2012 - 16:53
Brook

Hey Eric, is there a log file where virtualmin logs at what point it fails? I could look at that for clues.

Topic locked