I have installed PostgreSQL v7.1 in RedHat from RPM's and I have find some
bugs:
Stopping the service:
===============
When '/etc/rc.d/init.d/postgresql stop' try to stop 'postmaster' can't find
the 'postmaster.pid' file, and don't stop the postmaster daemon.
Y think it try to get in from $PGDATA/postmaster.pid , and it is locate in
'/var/run/postmaster.pid', so it don't works.
In the stop zone add:
killall -TERM postmaster
logs
===
The logs goes to /dev/null.
change "pg_ctl > /dev/null"
by
"pg_ctl > var/log/postgresql"
Access 'postmaster' through TCP/IP (it is not formerly a bug)
============================================
By default yo can't acces through TCP/IP, add this:
-o '-i'
then:
pg_ctl -o '-i'
Starting "PostgreSQL" when the server does.
================================
The installation script don't do this, you must do it if you wants that
'postmaster' starts when the server does.
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc3.d/S50postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc4.d/S50postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc5.d/S50postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc0.d/K25postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc1.d/K25postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc2.d/K25postgresql
ln -s /etc/rc.d/init.d/postgresql /etc/rc.d/rc6.d/K25postgresql
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
David Lizano - Director área técnica
correo-e: david.lizano@izanet.com
I Z A N E T - Servicios integrales de internet.
web: http://www.izanet.com/
Dirección: C/ Checa, 57-59, 3º D - 50.007 Zaragoza (España)
Teléfono: +34 976 25 80 23 Fax: +34 976 25 80 24
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~