Re: How can I set postmaster as a service

----- Original Message -----
From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Postgre Admin" <pgsql-admin(at)postgresql(dot)org>; "Postgre General"
<pgsql-general(at)postgresql(dot)org>; "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>
Sent: Saturday, September 06, 2003 10:53 AM
Subject: Re: [GENERAL] How can I set postmaster as a service

> I already had postgresql file in /etc/rc.d/init.d.
> I run the following ln commands as specified.
> if I boot my system it is opening database. But failing while opening
> database by remote host.
> May be -i option is missing.
>
> If I use the following line in postgresql file
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
> /usr/bin/postmaster -o '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null
>
> I could able to start database but I could not able to connect through
> remost host.
>
> If I change the option -o to -i I am getting an error while starting
> database itself.
>
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
> /usr/bin/postmaster -i '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null
>
> How can I rectify this error.
>
You do not need to change startup script, becuause there is option for
enabling tcp/ip in the postgresql configuration file.

Regards !