Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 24, 2006, 12:53 PM   #1
sk3pt1c
macrumors 6502a
 
Join Date: Nov 2005
Location: a simulacrum
unix help needed (postgreSQL)

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?
__________________
Vi Veri Veniversum Vivus Vici
Macbook Pro 15" Retina
sk3pt1c is offline   0 Reply With Quote
Old Jan 24, 2006, 01:20 PM   #2
thegreatunknown
macrumors regular
 
Join Date: Jan 2006
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.
thegreatunknown is offline   0 Reply With Quote
Old Jan 24, 2006, 01:21 PM   #3
bousozoku
Moderator emeritus
 
Join Date: Jun 2002
Location: Gone but not forgotten.
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.
bousozoku is offline   0 Reply With Quote
Old Jan 24, 2006, 01:28 PM   #4
thegreatunknown
macrumors regular
 
Join Date: Jan 2006
whoops thanks bous... I answered the wrong question. guess I need to read closer.
thegreatunknown is offline   0 Reply With Quote
Old Jan 24, 2006, 02:26 PM   #5
lexfuzo
macrumors 6502
 
Join Date: Mar 2005
Location: The heart of Europe
Quote:
Originally Posted by sk3pt1c
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?
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
__________________
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
lexfuzo is offline   0 Reply With Quote
Old Jan 25, 2006, 05:22 AM   #6
sk3pt1c
Thread Starter
macrumors 6502a
 
Join Date: Nov 2005
Location: a simulacrum
thanks people

sorted
__________________
Vi Veri Veniversum Vivus Vici
Macbook Pro 15" Retina
sk3pt1c is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
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

Forum Jump

All times are GMT -5. The time now is 09:24 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC