Thread: authentication error

authentication error

From
jie zhang
Date:
Hi,

I try to connect using psql test from localhost.  I got:
FATAL 1:  No pg_hba.conf entry for host localhost, user postgres,
database test

I double checked that I have done the following:
I started server using: postmaster -i -D /var/lib/pgsql/data >logfile
2>&1 &

In my pg_hba.conf file I have:
host       all         127.0.0.1     255.255.255.0    trust
local   all     reject

Are there anything else I need to do ?  or anything I did wrong ?
I try to force the connection go through tcp/ip.
Please advice if you can.

thanks in advance,

Jie


Re: authentication error

From
Gémes Géza
Date:
jie zhang írta:

> Hi,
>
> I try to connect using psql test from localhost.  I got:
> FATAL 1:  No pg_hba.conf entry for host localhost, user postgres,
> database test
>
> I double checked that I have done the following:
> I started server using: postmaster -i -D /var/lib/pgsql/data >logfile
> 2>&1 &
>
> In my pg_hba.conf file I have:
> host       all         127.0.0.1     255.255.255.0    trust
> local   all     reject
>
> Are there anything else I need to do ?  or anything I did wrong ?
> I try to force the connection go through tcp/ip.
> Please advice if you can.
> thanks in advance,
>
> Jie
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Can you connect without a host option if yes then check your
postgresql.conf file (should be in the same dir as pg_hba.conf)  check
for a line tcpip_socket = true if not found write it and then restart
the postmaster.

Good luck

Geza Gemes



Re: authentication error

From
Bijoy Chandrasekharan
Date:
> In my pg_hba.conf file I have:
> host       all         127.0.0.1     255.255.255.0    trust
> local   all     reject
>
hi,

Try changing the last line to

 local     all        trust

and restart the postmaster.

hope this helps.
regds,
bijoy.

Howto Setup a good PostgreSQL Server

From
"Stefan Sturm"
Date:
Hello,

where can I find a tutorial about 'HowTo setup a PostgreSQL Server'.
I don't mean howto install. I want to know what can I do to maximize the
Performance of the whole system.

I found some posting here, but this can't be all I can do...

Thanks for your Help,

Stefan Sturm