[OPEN-ILS-DEV] Postgres id/pw ?

[Hennie Rautenbach]

Mike Rylander wrote:
> On 5/8/07, Hennie Rautenbach <hennie at sabinet.co.za> wrote:
>> Hi there,
>>
>> Is there a simple way to verify the PostgresSQL id and pw from the Linux
>> Shell (command line) ?
>
> There is a shell for Postgres called psql.  Both
>
> $ psql --help
>
> and
>
> $ man psql
>
> will tell you how to use this to connect to PG.

If I am right then I should have been able to access the db with the 
following command:

opensrf at leo:/openils/conf$ psql -d evergreen -h leo.sabinet.co.za -U 
postgres -W
Password for user postgres: <typed in>

psql: FATAL:  no pg_hba.conf entry for host "198.54.80.26", user 
"postgres", database "evergreen", SSL off
opensrf at leo:/openils/conf$

Regards,

Hennie