[GENERAL] Cannot connect Postgresql 8.1 64 bit

2006-04-08 Thread amrit
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:
hostall all 127.0.0.1/32  trust sameuser
hostall all 192.168.0.0/255.255.0.0 trust   sameuser
# IPv6 local connections:
hostall 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

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [GENERAL] Cannot connect Postgresql 8.1 64 bit

2006-04-08 Thread Devrim Gunduz
Hi,

On Sun, 2006-04-09 at 05:30 +0700, [EMAIL PROTECTED] 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/


---(end of broadcast)---
TIP 6: explain analyze is your friend