Received: from avocet.mail.pas.earthlink.net (avocet.mail.pas.earthlink.net
	[207.217.121.50])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6BBDAa05472
	for <pgsql-admin@postgresql.org>; Wed, 11 Jul 2001 07:13:10 -0400 (EDT)
	(envelope-from nickf@ontko.com)
Received: from nick (1Cust63.tnt1.richmond.in.da.uu.net [63.27.103.63])
	by avocet.mail.pas.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id
	EAA06148; Wed, 11 Jul 2001 04:13:04 -0700 (PDT)
From: "Nick Fankhauser" <nickf@ontko.com>
To: "Xue-Feng Yang" <just4look@yahoo.com>
Cc: <pgsql-admin@postgresql.org>
Subject: RE: newbie question
Date: Wed, 11 Jul 2001 06:09:01 -0500
Message-ID: <NEBBLAAHGLEEPCGOBHDGOEPADEAA.nickf@ontko.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
In-reply-to: <20010711032426.26933.qmail@web14601.mail.yahoo.com>
Importance: Normal
X-Archive-Number: 200107/40
X-Sequence-Number: 1791


> Here is the file. Please give me more suggestions.

Actually, I think the best place to set this would be in the config file.
The right place depends on which version you are running.


If your version is lower than 7.1, put a line in postmaster.init that looks
like this:

PGALLOWTCPIP=yes


If your version is 7.1 or higher, put a line in postgresql.conf that looks
like this:

TCPIP_SOCKET = 1



On Debian Linux these files would be found in /etc/postgresql

I'm not sure where they live on other platforms.

-Nick