Обсуждение: Cannot connect Postgresql 8.1 64 bit

Поиск
Список
Период
Сортировка

Cannot connect Postgresql 8.1 64 bit

От
amrit@health2.moph.go.th
Дата:
I try to set  FC3 X64 and postgresql 64 8.1 in my new server but I cannot
connect it with pgadminIII. My pg_hba.conf is like below:


# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust sameuser
host    all         all         192.168.0.0/255.255.0.0 trust   sameuser
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser

No fire wall was set and i cannot set it via webmin because of module
configuration.
What should I set in postgresql.conf to be able to connect to my postgres
server?
Thanks.
Amrit
Thailand

Re: Cannot connect Postgresql 8.1 64 bit

От
Devrim Gunduz
Дата:
Hi,

On Sun, 2006-04-09 at 05:30 +0700, amrit@health2.moph.go.th wrote:
> I try to set  FC3 X64 and postgresql 64 8.1 in my new server but I cannot
> connect it with pgadminIII. My pg_hba.conf is like below:
>
> # "local" is for Unix domain socket connections only
> local   all         all                               ident sameuser

change ident sameuser to trust, reload PostgreSQL service... and read

http://www.postgresql.org/docs/8.1/static/client-authentication.html

about ident authentication.

Regards,

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/