--- Warso Prayitno <[EMAIL PROTECTED]> wrote: > > 1. ps ax | grep postmaster, cek apa postmaster > > running? > > hasilnya begini : > [bujung@bujung bujung]$ ps ax|grep postmaster > 2068 ? S 0:00 /usr/bin/postmaster > 2842 pts/0 S 0:00 grep postmaster
Artinya postmaster sudah running, krn di proses list di atas sudah ada dgn pid 2068. > > > 2. netstat -na | grep LISTEN, cek apakah Listen di > > port 5432? > > hasilnya begini : > [bujung@bujung bujung]$ netstat -na|grep LISTEN > tcp 0 0 0.0.0.0:1024 > 0.0.0.0:* LISTEN > tcp 0 0 127.0.0.1:1025 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:609 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:901 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:8200 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:904 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:3306 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:139 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:111 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:6000 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:10000 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:80 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:21 > 0.0.0.0:* LISTEN > tcp 0 0 192.168.0.2:53 > 0.0.0.0:* LISTEN > tcp 0 0 127.0.0.1:53 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:22 > 0.0.0.0:* LISTEN > tcp 0 0 127.0.0.1:953 > 0.0.0.0:* LISTEN > tcp 0 0 0.0.0.0:443 > 0.0.0.0:* LISTEN > unix 2 [ ACC ] STREAM LISTENING > 5572 > /tmp/ksocket-bujung/kdeinit-:0 > unix 2 [ ACC ] STREAM LISTENING > 5617 /tmp/.fam_socket > unix 2 [ ACC ] STREAM LISTENING > 4166 /tmp/.s.PGSQL.5432 > unix 2 [ ACC ] STREAM LISTENING > 3455 /var/prelude/socket > unix 2 [ ACC ] STREAM LISTENING > 5350 /tmp/.gdm_socket > unix 2 [ ACC ] STREAM LISTENING > 5445 > /tmp/medusa-idled-service > unix 2 [ ACC ] STREAM LISTENING > 4153 > /var/lib/mysql/mysql.sock > unix 2 [ ACC ] STREAM LISTENING > 5361 /tmp/.X11-unix/X0 > unix 2 [ ACC ] STREAM LISTENING > 5577 > /tmp/.ICE-unix/dcop2611-1034157566 > unix 2 [ ACC ] STREAM LISTENING > 5675 > /tmp/mcop-bujung/bujung_net-0a42-3da3fe04 > unix 2 [ ACC ] STREAM LISTENING > 5602 > /tmp/ksocket-bujung/klauncherN5RZSb.slave-socket > unix 2 [ ACC ] STREAM LISTENING > 5701 /tmp/.ICE-unix/2656 > unix 2 [ ACC ] STREAM LISTENING > 4571 /tmp/.font-unix/fs-1 > unix 2 [ ACC ] STREAM LISTENING > 3496 /dev/gpmctl Postgresql socketnya belum running, belum ada tuh yg listen di port 5432. > > > 3. Cek file postgresql.conf, apa sudah disetting > utk > > listen di IP dan port bersangkutan? > Ini yang belum pernah saya buka sama sekali. > Kondisi kokesi parameternya begini dan bagian mana > yang musti di seting ? > # Connection Parameters > #tcpip_socket = false > #ssl = false > #max_connections = 32 > #port = 5432 > #hostname_lookup = false > #show_source_port = false > #unix_socket_directory = '' > #unix_socket_group = '' > #unix_socket_permissions = 0777 > #virtual_host = '' > #krb_server_keyfile = '' > remark tcpip_socket dibuka dan set nilainya menjadi true remark port juga dibuka. Abis itu restart postgresql service-nya, dan coba lagi. Btw, seharusnya tanya yg kayak begini tuh di linux-admin, mas. Salam, Andry __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Utk berhenti langganan, kirim email ke [EMAIL PROTECTED] Informasi arsip di http://www.linux.or.id/milis.php3
