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
