unix help needed (postgreSQL)

Discussion in 'Mac Programming' started by sk3pt1c, Jan 24, 2006.

  1. macrumors 6502a

    sk3pt1c

    Joined:
    Nov 29, 2005
    Location:
    a simulacrum
    #1
    hi there,

    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?
     
  2. macrumors regular

    Joined:
    Jan 12, 2006
    #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:

    ssh login@servername

    it will ask for you password and you just type it in.

    hope this helps.
     
  3. Moderator emeritus

    Joined:
    Jun 25, 2002
    Location:
    Gone but not forgotten.
    #3
    That should get you to the server where your files exist but it won't likely access the database.

    You might try this documentation to get to know more about what the database server does and how to access it.
     
  4. macrumors regular

    Joined:
    Jan 12, 2006
    #4
    whoops thanks bous... I answered the wrong question. guess I need to read closer.
     
  5. macrumors 6502

    Joined:
    Mar 15, 2005
    Location:
    The heart of Europe
    #5
    Use psql (command-line). It is part of the PostgreSQL installation.
    `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:
    http://www.pgadmin.org
     
  6. thread starter macrumors 6502a

    sk3pt1c

    Joined:
    Nov 29, 2005
    Location:
    a simulacrum

Share This Page