Skip site navigation (1) Skip section navigation (2)

Re: Server starts, but I can't connect

From: Craigbert <postgresql(at)mysoftforge(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Server starts, but I can't connect
Date: 2011-07-06 04:14:50
Message-ID: 4E13E13A.50307@mysoftforge.com (view raw or flat)
Thread:
Lists: pgsql-novice
Tom,

Thanks for replying.

Here is the log:
2011-07-05 22:58:22 CDT LOG:  database system is ready to accept connections
2011-07-05 22:58:22 CDT LOG:  autovacuum launcher started
2011-07-05 22:59:33 CDT LOG:  could not receive data from client: 
Connection reset by peer
2011-07-05 22:59:41 CDT FATAL:  password authentication failed for user 
"postgres"
2011-07-05 22:59:41 CDT FATAL:  password authentication failed for user 
"postgres"
2011-07-05 23:02:00 CDT LOG:  could not receive data from client: 
Connection reset by peer
2011-07-05 23:02:01 CDT LOG:  could not receive data from client: 
Connection reset by peer
2011-07-05 23:04:32 CDT LOG:  could not receive data from client: 
Connection reset by peer

Here is the main part of my pg_hba.conf file:
# Database administrative login by UNIX sockets
local   all         postgres                          trust
#local   all         postgres                          ident --wcb 
original line

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# method above WAS ident --wcb
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5

I did a "find / -name pg_hba.conf" and this was the only file that was 
found.

Based on what you are saying and the log file I have set up my 
pg_hba.conf file incorrectly.

Any idea where I have gone awry?

Thanks,

Craigbert

On 07/05/2011 10:11 PM, Tom Lane wrote:
> Craigbert<postgresql(at)mysoftforge(dot)com>  writes:
>> Hello All,
>> I am running PostgreSQL 8.4 on Kubuntu 11.04.
>> The server starts without any issues, but I can not connect.  I keep
>> getting an invalid user/password error.
>> I am connecting to the localhost, default port, user = postgres,
>> database = postgres
>> I have tried setting the authentication methods to trust in the
>> pg_hba.conf file, but it does not make any difference.
>> What am I doing wrong?
> You could not get that type of error when running "trust"
> authentication.  So, you aren't.  Likely theories are that you forgot to
> reload or restart the server after changing pg_hba.conf, or that you did
> reload but it didn't "take" because of some error in the modified hba
> file (if so, there'll be some complaint about it in the server log
> file), or that the file you're changing isn't the one being used by the
> server you're actually connecting to.
>
> 			regards, tom lane
>

In response to

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2011-07-06 07:01:50
Subject: Re: Server starts, but I can't connect
Previous:From: Tom LaneDate: 2011-07-06 03:11:31
Subject: Re: Server starts, but I can't connect

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group