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

[Mike Rylander]

On 5/8/07, Hennie Rautenbach <hennie at sabinet.co.za> wrote:
> 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$

You'll need to adjust two files.  First, in postgresql.conf, you will
need to uncomment and change the listen_address setting to read:

listen_addresses = '*'

You can set that * to your IP address, and then ... well, what Dan
Wells said. :)

-- 
Mike Rylander