| From: | Maarten Boekhold <maartenb(at)dutepp0(dot)et(dot)tudelft(dot)nl> |
|---|---|
| To: | Peter Mount <pgsqladmin(at)retep(dot)org(dot)uk> |
| Cc: | The Hermit Hacker <scrappy(at)hub(dot)org>, "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>, Andy Lewis <alewis(at)mpsi(dot)net>, pgsql-admin(at)postgreSQL(dot)org, David Humphreys <dhumphre(at)nortel(dot)ca> |
| Subject: | Re: [ADMIN] postgresql-6.3.2 question |
| Date: | 1998-05-18 08:55:36 |
| Message-ID: | Pine.SUN.3.91.980518105329.28979A-100000@dutepp0.et.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> 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(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Martin | 1998-05-18 09:15:55 | Re: [ADMIN] postgresql-6.3.2 question |
| Previous Message | Bruce Momjian | 1998-05-18 01:42:15 | Re: [ADMIN] PostgreSQL questions |