Re: TCP/IP connection - Mailing list pgsql-admin

From Devrim GUNDUZ
Subject Re: TCP/IP connection
Date
Msg-id Pine.LNX.4.44.0312051449450.2398-100000@emo.org.tr
Whole thread Raw
In response to TCP/IP connection  (Ashok Chauhan <ashok@kalculate.com>)
List pgsql-admin
-----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-----


pgsql-admin by date:

Previous
From: Ashok Chauhan
Date:
Subject: TCP/IP connection
Next
From: Frank Finner
Date:
Subject: Re: TCP/IP connection