Q: How can I export a list of devices and their info?

This might lead in a better direction I have tried differenet options but not a port, do you know what port it uses?  It would be nice to access directly.  Does not make sense to have this server app without being able to have your produciton server drive it or atleast dump users and devices into it.

So just running the backup on the termianl will output all of the tables, even the ones I can not connect to?

Jaime, I will try that site again.  I could be doing something wrong but evertyime I try to connect as described I always get a Postgres is not running command.  I know it has to be since Server.app is using it.  Like I said I could be doing it wrong but it seems in the new OSX Server (this site is for Lion which is even before Mountain Lion Server and then became just OSX Server) is running another instance of postgress and hidding it.

I will try again and let you know.

So doin gthis,

psql -U _postgres -d device_management -h 127.0.0.1, might solve the proglem.

I hope so I have already corrputed the entire server trying to get access and lost 100 profiles, if this works I will be so happy.

Thanks

I thank you for taking your time to help, but either option did not solve my problem. 

I get this error,

Server$ psql -U _postgres -d device_management -h 127.0.0.1

psql: could not connect to server: Connection refused

          Is the server running on host "127.0.0.1" and accepting

          TCP/IP connections on port 5432?

This is the same error I have been getting, I do believe it has somethign to do with the port I think maybe osx server is using another port but I can not find it.

OK, I am sure I am retrarded and there is a much easier way to do this but I have finally got to the DB to get access to my device list.  Call it stubron but I find it stupid that Apple does not allow a simple export of a CSV files or import either for Devices or Users (if there is please let me know).

I am sure there is an easier way, but I am not that savy with permissions or user access so maybe if you can add yourself to _postgres user/group then maybe this is not needed but this is what I had to do.

In this file, /Library/Server/PostgreSQL For Server Services/Config/com.apple.postgres.plist, remove the last 2 elements in the array I believe it is -c and the other locks the port I believe with permissions of 0770.  After removeing those two lines, save the file and restart the server.

Then from there you sould be able to connect by

psql -U _postgres -d device_management -h /Library/Server/PostgreSQL\ For\ Server\ Services/Socket

good luck and be carful I am only using this to pull data not input.  Please let me know everything I did wrong or anything that could be easier.