Re: [ADMIN] postgresql-6.3.2 question

Поиск
Список
Период
Сортировка
От Maarten Boekhold
Тема Re: [ADMIN] postgresql-6.3.2 question
Дата
Msg-id Pine.SUN.3.91.980518105329.28979A-100000@dutepp0.et.tudelft.nl
обсуждение исходный текст
Ответ на Re: [ADMIN] postgresql-6.3.2 question  (Peter Mount <pgsqladmin@retep.org.uk>)
Список 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.Boekhold@et.tudelft.nl                         |
-----------------------------------------------------------------------------


В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [ADMIN] PostgreSQL questions
Следующее
От: Andrew Martin
Дата:
Сообщение: Re: [ADMIN] postgresql-6.3.2 question