[SAC] Deciphering Postgres on Adhoc

I had an interest in looking at oam.osgeo.org today. Noticed it wasn't
working and started poking around.

OAM is configured to use postgres on port 5433, database oam2

The only running instance of postgres I can find is on port 5434 and it
seems to only have db: postgres, template0, template1

There is something else running on post 5432, but I can't tell what it is.

I see source code that implies other versions of postgres may have been
built but can't find their postgresql.conf files to look at their settings.

Anyone have some clues on what might be going on?

Thanks,
Alex

On 09/29/2013 04:42 AM, Richard Duivenvoorde wrote:

On 29-09-13 08:14, Alex Mandel wrote:

I had an interest in looking at oam.osgeo.org today. Noticed it wasn't
working and started poking around.

OAM is configured to use postgres on port 5433, database oam2

The only running instance of postgres I can find is on port 5434 and it
seems to only have db: postgres, template0, template1

There is something else running on post 5432, but I can't tell what it is.

I see source code that implies other versions of postgres may have been
built but can't find their postgresql.conf files to look at their settings.

Anyone have some clues on what might be going on?

Hi Alex,

(probably old news for you, but?)

does:

netstat -lea | grep 5432

not reveal what is listenting there?

Richard Duivenvoorde

Right, I used netstat to check listening ports, and it appears to be a
postgres instance but it's not the system postgres. psql doesn't seem to
think it's connectable either.

So not really sure what the deal is. Thought someone might remember if
they compiled and started a custom built postgres on the system.

Thanks,
Alex

On Sun, Sep 29, 2013 at 08:57:22AM -0700, Alex Mandel wrote:

So not really sure what the deal is. Thought someone might remember if
they compiled and started a custom built postgres on the system.

As far as I can tell, there's one 'system' PostgreSQL (8.4) active and,
at the same time another one for MapServer "/osgeo/mapserver/fgs/".
This coincidences with my - pretty vague, to be honest - memory
claiming that the "adhoc" VM was a relevant ressource to the MapServer
project.

Cheers,
  Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------