Re: Server starts, but I can't connect

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

--
Michael Wood <esiotrot(at)gmail(dot)com>