Re: TCP/IP connection

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: Ashok Chauhan <ashok(at)kalculate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: TCP/IP connection
Date: 2003-12-05 12:53:05
Message-ID: Pine.LNX.4.44.0312051449450.2398-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gunduz(dot)org devrim(dot)gunduz(at)linux(dot)org(dot)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-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Frank Finner 2003-12-05 12:54:55 Re: TCP/IP connection
Previous Message Ashok Chauhan 2003-12-05 11:52:55 TCP/IP connection