On 6 July 2011 06:14, Craigbert <postgresql(at)mysoftforge(dot)com> wrote:
> 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
"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
> 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
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>
In response to
pgsql-novice by date
|Next:||From: Odysseus||Date: 2011-07-06 16:01:40|
|Subject: starting on functions (with little succes)|
|Previous:||From: Thom Brown||Date: 2011-07-06 07:01:50|
|Subject: Re: Server starts, but I can't connect|