Re: [SQL] Problems invoking psql. Help please. - Mailing list pgsql-novice

From Hugh Esco
Subject Re: [SQL] Problems invoking psql. Help please.
Date
Msg-id 5.1.0.14.0.20021122184815.02cec820@petra.cagreens.org
Whole thread Raw
In response to Re: [SQL] Problems invoking psql. Help please.  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-novice
Hey folks,

I'm back having made some limited progress, of sorts.

I attempted to run pg_ctl reload to update the pg_hba.conf file, which had
been edited while the postgreSQL server was running.  It gave me an error
message indicating that psql was not in my /usr/lib/postgresql/bin
directory.  So, on a whim, I copied it from my /usr/bin directory, dropping
an additional copy in the /usr/lib/postgresql/bin directory and ran pg_ctl
reload again, with good results.

That got me excited, thinking perhaps somehow my psql file just got
mis-filed and that perhaps I could invoke it's copy from its new home.  So
I ran:
>biko:/usr/lib/postgresql/bin# ./psql -U postgres ggp_test

and I didn't get an error message this time!  Oh happy day!  Top says that
psql is running using 3.7% of CPU and 0.5% of memory.  The hard disk has
been spinning ever since.  But I got no prompt.  Half an hour later, still
no prompt.

So I am back asking, what now?

I'm close.  I can sense it.

All help is appreciated.

-- Hugh Esco



pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Need help with currval and nextvall...
Next
From: Hugh Esco
Date:
Subject: A Newbie's Primer to postgreSQL