NOT able to browse all Postgres Databases (device_management) after the Server app update in Version 2.2

OS X Server v2.2 now stores Postgres data needed by services in its own database ("/Library/Server/PostgreSQL For Server Services" by default). If you migrate from a previous version of OS X Server, system Postgres data will be migrated from /Library/Server/PostgreSQL to "/Library/Server/PostgreSQL For Server Services". Any custom content you may have created in /Library/Server/PostgreSQL will remain there after upgrading to OS X Server v2.2. If you wish to access this data, or if you're installing OS X Server v2.2 for the first time and wish to create new Postgres data, you may need to start the service with this command:

sudo serveradmin start postgres

This will start a Postgres process separate from the one used by services, which can be used to serve your own content.

About the OS X Server v2.2 Update

I don't use PGAdmin, but I believe you would need to connect to the socket at

/var/pgsql_socket/.s.PGSQL.5432

Example, to connect to database "postgres" with role "_postgres":

sudo psql postgres -U _postgres -h "/Library/Server/PostgreSQL For Server Services/Socket"

when i use your command all i get is

psql: could not connect to server: Connection refused

Is the server running locally and accepting

connections on Unix domain socket "/Library/Server/PostgreSQL For Server Services/Socket/.s.PGSQL.5432"?

what next?

just fyi:

reason i'm trying to get the postgres_server running is that my profile manager, wiki, calendar and contacts have been acting up since update to 2.2

i found that you have to use

/Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend/wipeDB. sh

but when i do that, i get:

devicemgr:state = "STOPPED"

postgres_server:error = "CANNOT_START_SERVICE_TIMEOUT_ERR"

(in /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend)

Couldn't drop device_management : #<PGError: could not connect to server: Connection refused

Is the server running locally and accepting

connections on Unix domain socket "/Library/Server/PostgreSQL For Server Services/Socket/.s.PGSQL.5432"?

>

(in /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/backend)

could not connect to server: Connection refused

Is the server running locally and accepting

connections on Unix domain socket "/Library/Server/PostgreSQL For Server Services/Socket/.s.PGSQL.5432"?

looking at the code of wipeDB.sh, it shows that it is trying to start postgres_server with

sudo $SERVER_ROOT/usr/sbin/serveradmin start postgres_server

if i look at the postgres_server with

sudo serveradmin fullstatus postgres_server

i get

postgres_server:dataDirHasBeenInitialized = yes

postgres_server:PG_VERSION = "9.2.1"

postgres_server:dataDir = "/Library/Server/PostgreSQL For Server Services/Data"

postgres_server:postgresIsResponding = no

postgres_server:dataDirIsDirectory = yes

postgres_server:PGserverVersion = 0

postgres_server:dataDirExists = yes

postgres_server:setStateVersion = 1

postgres_server:state = "RUNNING"

which shows that the server is running but it's not responding.

after a long search i ended up in this thread.

i think the problem is that my postgres_server is not working properly.

and i have no idea why...

any help/pointers GREATLY appreciated.

thanks

Repairing permissions solved my problem. God knows why...

😕

The paths to any Postgres binary should always be spelled out in full to ServerRoot inside Server.app, as the default versions in your path (in /usr/bin) are 9.14, vs 9.2.1 in the server.

So, to connect to the device_management database as its owner, _devicemgr, use:

/Applications/Server.app/Contents/ServerRoot/usr/bin/psql -h '/Library/Server/PostgreSQL For Server Services/Socket/' -U _devicemgr device_management;

I can try, but I was unsuccessful getting a third party app (round cube) to connect to this instance of psql. What parameters does pgadmin ask you for? Is there any commented-out text in the config file describing those parameters?

By specifying it, assuming pgadmin let's you do that. You'd have to check its documentation and/or config file for information about how to specify the use of a socket. I noticed in 10.7's Round Cube installation, a socket was specified with "unix(/var/pg_socket)" in place of the hostname. I tried to mimick that with Round Cube in 10.8, by specifying the host as "unix('/Library/Server/Postgres for Services/Socket/')", but that didn't work. So yeah, you need to find out his pgadmin requires you to specify a socket.

I could connect to device_management via pgadmin by following settings...

Host: /Library/Server/PostgreSQL For Server Services/Socket

Port: 5432

MaintenanceDB: device_management

Username: _devicemgr

if the error msg shows "Is the server running locally and accepting connections on Unix domain socket "/Library/Server/PostgreSQL For Server Services/Socket/.s.PGSQL.5432"?", you could login with account root and try again.