|Jan 24, 2006, 12:53 PM||#1|
unix help needed (postgreSQL)
i need to access my university's database and see my tables that i created in a lab exercise we had. we're learning sql and we created some basic tables today.i just finished installing postgreSQL, which is what we'll be using for the rest of the semester,but i don't know what command i should use to try to connect to their server
i tried doing
ssh <server name>
but it asked for a password and when i entered it i got denied entry
am i using the right command or not?
Vi Veri Veniversum Vivus Vici
Macbook Pro 15" Retina
|Jan 24, 2006, 01:20 PM||#2|
for help type "man <command>" in your command line... for example "man ssh" will give you details about how to use it.
the most probable answer for your problem is that you are logging into a secured server meaning you need a log in name and password. by default ssh uses whatever the account name is on the computer you are signing in from as your log in name. so an easy way to use a different log in name is:
it will ask for you password and you just type it in.
hope this helps.
|Jan 24, 2006, 02:26 PM||#5|
`man psql` will help you.
You can use it to access your local DB or a remote one if the remote allows that.
If you manage to login on the remote server with ssh you can use psql there. Note that the passswords for login and database access may be different.
You could take a look at pgadmin3, too:
Proud owner of an iBook 12/1.33
Soon upgrading to a MacBook Con
Last edited by bousozoku; Jan 24, 2006 at 02:56 PM. Reason: posts next to each other
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|Using OS X Server PostgreSQL database for non-Server use||philbeeney||Mac OS X Server, Xserve, and Networking||3||Feb 19, 2014 05:07 PM|
|Unix||YOO-NIX||Mac Basics and Help||4||Jul 20, 2013 06:05 PM|
|How UNIX is OS X?||Caze||OS X||10||Jun 16, 2013 03:43 PM|
|UNIX/linux||monkeybagel||Mac Pro||6||Nov 30, 2012 02:54 AM|
|UNIX question (easy)||thenightwatch||OS X||5||Oct 4, 2012 08:40 AM|
All times are GMT -5. The time now is 10:05 AM.