Re: hi i need to connect database from my system to another system

> I am using postgresql database server... in my system.. if I want to
> connect to this database server from other system..Or how can I use this
> database server in other machine ..
>
> How can I do this..if any one have idea about this please give me brief
> description

You need to start the postgresql server with the "-i" option to allow TCP/IP connections. Then
you need to configure your pg_hba.conf file to set the permissions about which users can connect
to which databases.

Notice the pg_ctl section for starting postgresql.
http://www.postgresql.org/docs/8.1/interactive/app-pg-ctl.html

Notice the -o "options" section that can be set. (in this case you want -i)
http://www.postgresql.org/docs/8.1/interactive/app-postmaster.html

Finally notice, the section on the pg_hba.conf file.
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html#AUTH-PG-HBA-CONF

Also, secure shell also works well when connecting from another system.

Regards,

Richard Broersma Jr.