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-07 04:06:47
Message-ID: 4E1530D7.4020101@mysoftforge.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Roland de la croixDate: 2011-07-08 17:38:32
Subject: instalation
Previous:From: Michèle GarocheDate: 2011-07-06 22:59:42
Subject: Request over partition and join

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