Re: How can I set postmaster as a service

----- Original Message -----
From: "shreedhar" <shreedhar@lucidindia.net>
To: "Postgre Admin" <pgsql-admin@postgresql.org>; "Postgre General"
<pgsql-general@postgresql.org>; "Reid Thompson" <Reid.Thompson@ateb.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 !