RE: database connection problem

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

[Deiter] You probably have a postmaster.opts file.

Add the switch to the file, you should not change startup scripts.

Remember, when you upgrade Redhat again, you'll be wondering why the
heck it doesn't work when it worked before.

[Jeff] I agree, changing the init.d is bad. I found the postmaster.opts
file in /var/lib/pgsql. However, it looks as if there's a complete and
independent command line in the init.d script, does it even accede to
the postmaster.opts as an override when invoked by the init.d script
without any further coaxing?

My initial impression is that it doesn't, since:

1) (as su postgres) I add '-i' to /var/lib/pgsql/postmaster.opts, as
follows:
/usr/bin/postmaster '-i' '-D' '/var/lib/pgsql/data'

2) (as su root) I then run the RH7.1 standard '/etc/rc.d/init.d/postgres
restart':

3) ps -ax | grep postmaster shows:
/usr/bin/postmaster -D /var/lib/pgsql/data
indicating tha it ignored the .opts file.

4) and here's the kicker: Whatever is going on, it rewrites
postmaster.opts to the original form! All changes are lost!

This a strange startup environment, to be sure.

I would attach the RH7.1 init.d/postgres script, but it's outside of
mailinglist etiquette, AFAIK.