Connect to pgsql database in linux
I have SDP installed in linux.
HOw do I access the database via command line to review structure and such?
I navigated to ManageEngine/ServiceDesk/pgsql/bin
HOw do I access the database via command line to review structure and such?
I navigated to ManageEngine/ServiceDesk/pgsql/bin
- ./psql -U postgres -p 65432 -d servicedesk
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.65432"
I'm using port 65432 as that is what it seems to be using:
- postgres 1271 0.0 0.2 60140 10944 ? S Aug17 3:54 /srv/servicedesk/ManageEngine/ServiceDesk/pgsql/bin/postgres -D /srv/servicedesk/ManageEngine/ServiceDesk/pgsql/data -p65432