[Babase] connecting to psql

Karl O. Pinc babase@www.eco.princeton.edu
Wed, 05 Oct 2005 19:12:37 +0000


On 10/05/2005 01:43:31 PM, Leah Gerber wrote:
> Hi Karl,
> 
> I have been doing some online searches to try to figure out what psql  
> on the unix server is all about.

The place to look is the man command:
man psql

  Once I figure it out I will write
> some documentation that is babase specific so others can use it if  
> desired. I was hoping to try out the \copy command but I can't figure  
> out how to logon with psql. I tried
> 
> $ psql babase_test
> 
> psql: could not connect to server: Permission denied
>        Is the server running locally and accepting
>        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

You're telling it to connect to the babase_test computer.  You want:

psql -d babase_test

to connect to the babase_test database.

> 
> I am wondering which directory I should be in to try this? I am not  
> sure where the actual database is located on papio and if it matters  
> where I am when I try psql?

It does not matter, because you can/will give a full pathname to the
file you want to load.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein