Re: [BUGS] Postgres 8.1 hangs at boot time due to password authentication for user postgres.

#1

Rolf Gross wrote:

Quote:

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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Postgres 8.1 hangs at boot time due to password authentication for user postgres.

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Postgres 8.1 hangs at boot time due to password authentication for user postgres. - 12-16-2005 , 01:11 PM