Обсуждение: checkpoint

Поиск
Список
Период
Сортировка

checkpoint

От
TPCCUVA
Дата:
Hello.

I need to make checkpoints exactly every 30 minutes since a specifict
moment when a program starts.

It's necesary that postgres doesn't make checkpoints automatically.

Can you help us

Is there any log file where postgres records information about the
checkpoint that has been made?

I'm using postgres 7.1.3.

Thanks.

Re: checkpoint

От
Bruce Momjian
Дата:
TPCCUVA wrote:
> Hello.
>
> I need to make checkpoints exactly every 30 minutes since a specifict
> moment when a program starts.
>
> It's necesary that postgres doesn't make checkpoints automatically.
>
> Can you help us
>
> Is there any log file where postgres records information about the
> checkpoint that has been made?
>
> I'm using postgres 7.1.3.

Sure, there is a CHECKPOINT command that does exactly that.  Run it
every 30 minutes from cron using psql.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026