Re: How to write jobs in postgresql

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: How to write jobs in postgresql
Дата
Msg-id 20050805132007.GA97599@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: How to write jobs in postgresql  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]

On Fri, Aug 05, 2005 at 06:28:04PM +0530, chiranjeevi.i wrote:
> I have to dump up my database into a text file(using copy) at 2 am on every
> day. And from that I have to get the database details. & please don't
> suggest me to go for CRON as it has caused so many problems in my server.

I'll suggest cron anyway because that's the usual way to schedule
commands to run at regular times on Unix-like platforms.  If you're
having problems with cron then you should investigate and fix those
problems.

The pgAdmin folks have been working on a scheduler called pgAgent.
Use a search engine to find more information about it.

--
Michael Fuhr

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Optimizing large data loads
Следующее
От: Tom Lane
Дата:
Сообщение: Re: renaming a table, and its primary key constraint