Hi all,
Can anyone please tell me how to modify the postgresql startup script to accept TCP/IP connections? This is on a Redh Hat 9 machine running Postgresql 7.3.4 RPM installation. The RPMs were compiled from the SRPM available at postgresql.org.
The script in question is: /etc/rc.d/init.d/postgresql
The relevent line, I think, is:
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
However, when I stick a –i in there the server fails to start up. Can anyone tell me how to do this correctly?
TIA,
Balazs