From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Rolf Gross <rolf(dot)gross(at)gmx(dot)de> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Postgres 8.1 hangs at boot time due to password authentication for user postgres. |
Date: | 2005-12-16 19:11:17 |
Message-ID: | 20051216191117.GC26971@surnet.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-16 19:51:55 | Re: Solaris cc compiler on amd: PostgreSQL does not have native spinlock support on this platform |
Previous Message | Neil Conway | 2005-12-16 18:56:31 | Re: plpgsql TEMP table issue not fixed in 8.1? |