Skip navigation

Barusan kotak – katik servernya postgreSQL yang di linux (SuSE 10), kalau untuk koneksi internal / local (127.0.0.1) normal, bisa melakukan proses query dengan account “postgres” no problemo….

Trus…,mo connect dari windows box dengan account yang sama,…… ndak bisa???
coba cek di konfigurasi-file dari postgreSQL :

Window XP (pg_hba.conf
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all @admins,+support md5
host all all 192.168.0.0/24 md5 ### ini yang di tambahin…
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
#


connection from another PC is OK…

SuSE 10 (pg_hba.conf)
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# “local” is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
host all all 192.168.0.0/24 md5 ### ini yang di tambahin…
# IPv6 local connections:
#host all all ::1/128 ident sameuser
#


heh ternyata tidak bisa………!

langsung to the point aja-lah
konfigurasi yang benernya (minimal saat ini di SuSE 10) biar bisa jalan adalah sbb:

SuSE 10 (pg_hba.conf)
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# “local” is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
host all all 192.168.0.0/24 trust ### ini yang di tambahin…
# IPv6 local connections:
#host all all ::1/128 ident sameuser
#


dan konfigurasi di postgresql.conf :

#—————————————————————————
# CONNECTIONS AND AUTHENTICATION
#—————————————————————————
# – Connection Settings –
listen_addresses = ‘*’ # –ini yang di uncomment–
# comma-separated list of addresses;
# defaults to ‘localhost’, ‘*’ = all
# port = 5432
#


nah sekarang bisa enjoy utak atiknya pake EMS ama pake Navicat….

btw…, jika ada yang punya konfigurasi yang lebih ok bisa di share di comment-nya ya…. pleazeee…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: