Re: postgresql 7.1.3 - Mailing list pgsql-general

From Lamar Owen
Subject Re: postgresql 7.1.3
Date
Msg-id 200205062145.02299.lamar.owen@wgcr.org
Whole thread Raw
In response to postgresql 7.1.3  ("samsom, debra" <dsamsom@bristol.ca>)
List pgsql-general
On Monday 06 May 2002 12:37 pm, David Fee wrote:
> Owen,
> Do you know how to get postmaster to start with the " -i " flag?  I want to
> use pgaccess and when I try to connect to the db, it gives an error message
> saving that the postmaster isn't running with the " -i " flag or accepting
> connections at port 5432.  If I start postmaster with " -i  " manually, it
> works fine, but I need it to start automatically

Find the file 'postgresql.conf' -- on RedHat with an RPM installation it is in
/var/lib/pgsql/data.  Edit this file -- change the line '#tcpip_socket =
false' to be 'tcpip_socket = true'  -- note the lack of the # comment.

Restart postmaster and you're done.  The -i switch is no longer necessary due
to the 'GUC' -- 'Grand Unified Configuration' file postgresql.conf.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

pgsql-general by date:

Previous
From: "Andrew Bartley"
Date:
Subject: time in 7.2
Next
From: Francisco Reyes
Date:
Subject: Re: Problems with list?