Thread: TCP/IP connection

hi

i want to accsess my postgresql data base from network it is only
possible when i start postgresql by following command:-
postmaster -i -D /var/lib/pgsql/data
after rebooting the system it does not listen for TCP/IP connection.
how can i configure it for listening TCP/IP connection after rebooting.
plz help me.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On 5 Dec 2003, Ashok Chauhan wrote:

> i want to accsess my postgresql data base from network it is only
> possible when i start postgresql by following command:-
> postmaster -i -D /var/lib/pgsql/data
> after rebooting the system it does not listen for TCP/IP connection.
> how can i configure it for listening TCP/IP connection after rebooting.

edit /var/lib/pgsql/data/postgresql.conf .

Uncomment tcpip_socket option and set it to true.

tcpip_socket = true

Then PostgreSQL will listen to 5432, its default port. If you need to
change it, edit port option.

You need to restart PostgreSQL for the changes to take effect when you
edit the conf file.

Regards,
- --
Devrim GUNDUZ
devrim@gunduz.org                devrim.gunduz@linux.org.tr
            http://www.TDMSoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/0H+ytl86P3SPfQ4RAk4jAKDJnSM1LpyRDrsr7sYAl5wEPhKXHgCeI17v
W0nWFKNJcHk8g1eK8cCByJ4=
=xYyw
-----END PGP SIGNATURE-----

On Fri, 5 Dec 2003 17:22:55 +0530
pgsql-admin-owner@postgresql.org wrote:

> hi
>
> i want to accsess my postgresql data base from network it is only
> possible when i start postgresql by following command:-
> postmaster -i -D /var/lib/pgsql/data
> after rebooting the system it does not listen for TCP/IP connection.
> how can i configure it for listening TCP/IP connection after
> rebooting. plz help me.
>

In postgresql.conf, set tcpip_socket = true.

Regards, Frank