configuration postgresql

buncit : 16:45 WIB( waktu insan beriman)

setelah mencoba menghubungkan antara web reporting dengan database postgresql,error deh..^_^
nyerah?tentu tidak(dah 3 hari mengerjakannya),akhirnya phone a fren..hehehe.
eko wahyudi akhirnya memberi pencerahan..

sebelumnya ku sudah setting configurationnya.tapi tetap juga blom bisa.
masuk ke direktori

untuk melihat file nya pg_hba.conf
[root@localhost ~]# locate pg_hba.conf


[root@localhost ~]# vi /var/lib/pgsql/data/pg_hba.conf
# PostgreSQL Client Authentication Configuration File
# ===================================================

......
......
......

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all password
# IPv4 local connections:
host all all 192.168.0.0/24 trust
host all all 127.0.0.1/32 trust

# IPv6 local connections:
host all all ::1/128 ident sameuser

setelah setting configurasi direktori pg_hba.conf kita ke ...

[root@localhost ~]# vi /var/lib/pgsql/data/postgresql.conf

#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port = 5432
max_connections = 100
# note: increasing max_connections costs ~400 bytes of shared memory per
# connection slot, plus lock space (see max_locks_per_transaction). You
# might also need to raise shared_buffers to support more connections.
#superuser_reserved_connections = 2
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
#bonjour_name = '' # defaults to the computer name


setelah itu kita restart
[root@localhost ~]# service postgresql restart
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
[root@localhost ~]# service iptables stop
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]