Currently Being ModeratedDec 11, 2012 5:16 PM (in response to toddatkuapay)
Ok well I've found the database but can not find out how to connect and retrieve the data from it. I need to backup my database and then use the data for an inhouse inventory database...
Any help appreciated.
Currently Being ModeratedDec 12, 2012 8:47 AM (in response to toddatkuapay)
So there are now 2 postgres servers running and I can't connect to the /Library/Server/PostgreSQL For Server Services...
The reason for this is that psql is pointing to the original location of the socket directory. By simply shutting down the 2nd instance of the Postgres database and linking the running socket in the original socket directory - you can connect to the /Library/Server/PostgreSQL for Server Services instance.
1.) launchctl remove org.postgresql.postgres
2.) launchctl list | grep postgre
3.) ln -s /Library/Server/PostgreSQL\ For\ Server\ Services/Socket/.s.PGSQL.5432 /var/pgsql_socket/.s.PGSQL.5432
And you can connect to the database you need by:
psql -U _postgres -d postgres
Currently Being ModeratedDec 14, 2012 8:32 AM (in response to toddatkuapay)
You can also use:
psql -U _postgres -h /Library/Server/PostgreSQL\ For\ Server\ Services/Socket/ -lt
Currently Being ModeratedDec 14, 2012 8:38 AM (in response to Peter Jurg2)
Peter - thank you! That's a more elegant solution...