Re: [SQL] Problems invoking psql. Help please.

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