There is a small example copied from postgreSQL.org
[codesyntax lang=”c” tab_width=”4” strict=”yes”]
above is how to connect localhost database. If you want to connect with remote postgreSQL server. You will following those rules(copied from vivek):
Once connected, you need edit the PostgreSQL configuration file, edit the PostgreSQL configuration file /var/lib/pgsql/data/pg_hba.conf (or /etc/postgresql/8.2/main/pg_hba.conf for latest 8.2 version) using a text editor such as vi.
Login as postgres user using su / sudo command, enter:
Edit the file:
Append the following configuration lines to give access to 10.10.29.0/24 network:
Save and close the file. Make sure you replace 10.10.29.0/24 with actual network IP address range of the clients system in your own network.
You need to enable TCP / IP networking. Use either step #3 or #3a as per your PostgreSQL database server version.
If you are using PostgreSQL version 8.x or newer use the following instructions or skip to Step # 3a for older version (7.x or older).
You need to open PostgreSQL configuration file /var/lib/pgsql/data/postgresql.conf or /etc/postgresql/8.2/main/postgresql.conf.
Find configuration line that read as follows:
Next set IP address(es) to listen on; you can use comma-separated list of addresses; defaults to ‘localhost’, and ‘*’ is all ip address:
Or just bind to 184.108.40.206 and 220.127.116.11 IP address
Save and close the file. Skip to step # 4.
Following configuration only required for PostgreSQL version 7.x or older. Open config file, enter:
Bind and open TCP/IP port by setting tcpip_socket to true. Set / modify tcpip_socket to true:
Save and close the file.
Type the following command:
Make sure iptables is not blocking communication, open port 5432 (append rules to your iptables scripts or file /etc/sysconfig/iptables):
Use psql command from client system. Connect to remote server using IP address 10.10.29.50 and login using vivek username and sales database, enter: