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?
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.
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.