postgres_real process?

Classic Servoy
1

I have set up a brand new Mac OS X Lion Server and installed the postgresql-9.1.4-1-osx.dmg from EnterpriseDB as on many other previous installations.
But now I have two different processes/services and users of PostgreSQL running. A “postgres” process for the “postgres” user and a “postgres_real” process for the “_postgres” User.
Where does the “postgres_real” and user “_postgres” comes from and why do I have this two different postgresql instances?

Regards,

psql_service.png
psql_service.png803×236 78.7 KB

2

Hi Thomas,

You say you run Lion Server. This version comes with PostgreSQL bundled (they dropped MySQL in favor of Pg).
So the postgres_real is the one that came with the OS. The other is the EDB installed version.

Hope this helps.

3

Hi Robert,

is it a problem running both at the same time and do I and/or the OS need the postgres_real?

I don’t like it to have two different PostgreSQL server running.

Regards,

4

Hi Thomas,

It’s not a problem to run 2 instances next to each other. Each instance will use their own portnumber.
I believe postgres_real is used for the wiki and such. I did some googling and found the following info on how to connect to this instance.

Hope this helps.

5

Hi Robert,

thank you!

For me it’s more handy and easier to administrate the EnterpriseDB installation of PSQL because of updating to newer versions etc.

Regards,