On 06/09/2003 09:53 shreedhar wrote:
> 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.
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster '-p ${PGPORT}' start -o \" -i \" > /dev/null 2>&1" <
/dev/null
or in postgresql.conf
tcpip_socket = true
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+