> I've installed it both ways:
>
> * As root, when installing under /usr/local
> * As postgres, when installing under /home/postgres
>
> The only thing I have yet to find how to setup without root, is starting
> the postmaster when the system boots.
You can use a cron-job for this. Let it test if postmaster is running,
and if not start it. Run this script every 5 minutes.
I use a perl-script in combination with a shell-script. The perl-script
also tests if there's any response from the postmaster. If not, it first
tries to kill all postgres/postmaster instances with -TERM, if that does
not work, try the same with -KILL, and then start them again by calling
the shell-script.
Maarten
_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M.Boekhold@et.tudelft.nl |
-----------------------------------------------------------------------------