[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