Re: How do I start postmaster with -i for tcp-ip

On 06 Jun 2001 09:32:21 -0400, Joe Moraca wrote:
> I am using Mandrake 8.0 and have upgraded to postrgess 7.1 and need to have
> the script that auto starts postgress use the -i so I can connect with jdbc
> but it seems I am not able to find the correct spot to put the -i as I never
> seem to get it to work....

This should really be a FAQ:

If you want to hardcode it into the rc script:

su -l postgres -c "PGDATESTYLE=GERMAN LANG=de_DE LANGUAGE=
LC_COLLATE=POSIX LC_CTYPE= LC_MESSAGES= LC_MONETARY= LC_NUMERIC=
LC_TIME= /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o \"-D
/usr/local/pgsql/data -i\" start >/dev/null 2>&1"

Adjust paths etc. to your needs.

P.S.: Don't forget the \ characters

--
 Nabil Sayegh