Re: postgresql 7.1.3

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