RE: database connection problem

[Jeff K. <jt...@ad...>]

[Thomas Good] I use Lamar's script (the one in /etc/rc.d/init.d) without
modification on RH 6.1 and RH 7.0 and it runs sql-ledger fine.

In fact...

ps ax | grep postmaster
shows:  
/usr/bin/postmaster -i

[Jeff] Thanks for that tip on ps -ax showing the arguments passed. I am
using RH7.1 and PostgreSQL 7.1.2-5PGDG, installed from the RPMS. My
'/etc/rc.d/init.d/postgres' script runs with the following arguments:

ps ax | grep postmaster
shows:  
/usr/bin/postmaster -D /var/lib/pgsql/data

So, I guess I need to find out where in this init.d line the '-i' should
be placed.

su -l postgres -s /bin/sh -c "/usr/bin/pgctl  -D $PGDATA -p
/usr/bin/postmaster start > /dev/null 2>&1" < /dev/null

placing -i on either side of the 'start', or before the -D causes the
init.d script to fail startup.

Thanks for the iterative help here. This mailing list is pretty
responsive.