Home > OpenERP, Postgresql > Remotely Access Postgresql from different clients

Remotely Access Postgresql from different clients

Step 1:

Open pg_hba.conf and postgresql.conf using below commands.

$ sudo gedit /etc/postgresql/8.4/main/postgresql.conf

$ sudo gedit /etc/postgresql/8.4/main/pg_hba.conf

Setp 2:

change the line listen_addresses =’localhost’ in postgresql.conf to listen_addresses=’*’

save the file

Step 3:

insert a new line under IPv4 local connections

host        all        all        192.168.1.0 255.255.255.0         trust

and save the file. Above mention IP  is the IP range that will connect to postgresql server

Step 4:

restart the postgresql service using below command.

sudo /etc/init.d/postgresql-8.4 restart

Step 5:

from postgresql client connect with postgresql server using following information

host: postgresql server ip

port: 5432

username: postgresql server username

password: password of above mention user name

Note: if clients gives error then try to connect after setting firewall off at postgresql server or define a new profile for this above mention port and IP in firewall.

Categories: OpenERP, Postgresql
  1. December 4, 2011 at 10:30 am

    Sir clear me about demo data?

    sir if we want to move a module of openerp with his records then we use demo data consept can you explian the demo data file created?

    Sangeen doing MCS from IMScinece 2nd semester.

  2. December 7, 2011 at 5:15 am

    Brother! when u try to define the functionality of your module having some existing data entered already as a part of installation. Using this demo data any viewer can understand how should he/she entered data in your developed objects. In some situation we can also use this demo data concept for default configuration of your module.

  1. No trackbacks yet.

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: