Re: TCP/IP connection

-----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-----