Re: Strange startup error

From: Peter Wiersig <peter(at)friesenpeter(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange startup error
Date: 2006-03-17 20:42:09
Message-ID: 20060317204209.GA17946@london087.server4you.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 17, 2006 at 03:05:17PM -0500, Andrew Stewart wrote:
> I have had postgres working perfectly up until recently. Now suddenly I
> get an error when trying to run postgres:
>
> % psql
> psql: FATAL: No pg_hba.conf entry for host localhost, user postgres,
> database postgres
>
> % postmaster &
> LOG: could not bind Unix socket: Address already in use
> HINT: Is another postmaster already running on port 5432? If not,
> remove socket file "/tmp/.s.PGSQL.5432" and retry.
>
> Anyone have an ideas?

Postgres is running, no need to start postmaster.

Read the psql message, read the chapter
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
and configure pg_hba.conf to meet your needs.

"pg_ctl reload" afterwards.

Peter

In response to

Browse pgsql-general by date

  From Date Subject
Next Message William Leite Araújo 2006-03-17 20:46:45 Re: Strange startup error
Previous Message William Leite Araújo 2006-03-17 20:40:06 Server "deadlock"?