$ psql -h localhost -p 1000 -U yorkie databasename > input password Further reading: http://jurjenbokma.com/ApprenticesNotes/connecting_to_a_remote_postgresql_server.html http://stackoverflow.com/questions/3582552/postgres-connection-url