Re: Server starts, but I can't connect

Thanks Michael and everyone else. You guys nailed it. I was setting
the UNIX sockets to trust instead of IP.

Craigbert

On 07/06/2011 06:26 AM, Michael Wood wrote:
> Hi
>
> On 6 July 2011 06:14, Craigbert<postgresql(at)mysoftforge(dot)com> wrote:
>> Tom,
>>
>> Thanks for replying.
>>
>> Here is the log:
> [...]
>> 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
> "local" is for UNIX domain sockets, not TCP/IP networking.
>
>> # 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
> Here you're specifying that when someone connects over TCP/IP to
> localhost, they must use a username and password using MD5 for the
> password hashing algorithm.
>
>> # 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?
> Unless you can't (e.g. you're using JDBC or something), try connecting
> to the UNIX domain socket instead of over TCP/IP. If this is not an
> option, try changing "md5" to "trust" for the "host ... 127.0.0.1/32"
> line. But I don't recommend this. It would be better to set up a
> username and password and use that.
>
> If you're just trying to connect using psql as user postgres, try this:
>
> craigbert(at)kubuntu$ sudo su - postgres
> postgres(at)kubuntu$ psql
>
> If you don't specify a host it should use the UNIX domain socket
> instead of TCP/IP.
>
>> 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