Re: Postgres 8.1 hangs at boot time due to password authentication for user postgres. - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Postgres 8.1 hangs at boot time due to password authentication for user postgres.
Date
Msg-id 20051216191117.GC26971@surnet.cl
Whole thread Raw
In response to Postgres 8.1 hangs at boot time due to password authentication for user postgres.  (Rolf Gross <rolf.gross@gmx.de>)
List pgsql-bugs
Rolf Gross wrote:

> after upgrading from PostgreSQL 7.4 to 8.1 on my Debian PC (Testing
> Release) PostgreSQL hangs at boot time.  This is because user
> "postgres" was set to password authentication in my database.  The
> function "/usr/bin/pg_ctlcluster - cluster_port_ready" tries to
> connect to the database using "psql" which prompts for the password
> then. But the password cannot be entered at boot time.  Changing user
> "postgres" to "ident" authentification removes the problem. But in my
> opinion it should be possible to use password authentication.

This pg_ctlcluster program seems to be Debian-specific, so please report
issues with it to the Debian team.  (I don't even know what it's
supposed to do.)

Anyway, with password authentication there's no way to connect without a
password.  I don't think there's a way around that.  You could set the
authentication to ident for the specific database and user that
pg_ctlcluster is using; or you could set a .pgpass file.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-bugs by date:

Previous
From: Neil Conway
Date:
Subject: Re: plpgsql TEMP table issue not fixed in 8.1?
Next
From: Tom Lane
Date:
Subject: Re: Solaris cc compiler on amd: PostgreSQL does not have native spinlock support on this platform