md5 is invalid?

From: Robert C Paulsen Jr <robert(at)paulsenonline(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: md5 is invalid?
Date: 2004-03-29 00:25:43
Message-ID: 1080519943.21114.18.camel@avalon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I am trying to setup postgresql 7.4.2 on Red Hat Enterprise ver 3.0.

I installed every rpm from the download directory:

$ rpm -qa | grep postgres
postgresql-docs-7.4.2-1PGDG
postgresql-contrib-7.4.2-1PGDG
postgresql-test-7.4.2-1PGDG
postgresql-libs-7.4.2-1PGDG
postgresql-debuginfo-7.4.2-1PGDG
postgresql-pl-7.4.2-1PGDG
postgresql-7.4.2-1PGDG
postgresql-devel-7.4.2-1PGDG
postgresql-python-7.4.2-1PGDG
postgresql-server-7.4.2-1PGDG
postgresql-tcl-7.4.2-1PGDG
postgresql-jdbc-7.4.2-1PGDG

I did "initdb -W -D /var/lib/pgsql/data" and it apparently worked.

I added a line to pg_hba.conf:

host all 192.168.0.0 255.255.255.0 md5

I started the server via "service postgresql start" and it appears to be
running OK.

I tried to log into the server (from userid postgres) but it failed:

$ psql template1
psql: FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.

The log file shows:

LOG: invalid entry in pg_hba.conf file at line 67, token "md5"
FATAL: missing or erroneous pg_hba.conf file
HINT: See server log for details.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-03-29 00:44:01 Re: md5 is invalid?
Previous Message Tom Lane 2004-03-28 15:36:59 Re: License for PostgreSQL for commercial purpose