> 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             |
|                          [EMAIL PROTECTED]                         |
-----------------------------------------------------------------------------


Reply via email to