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