Re: pg_restore

From: "D Kavan" <bitsandbytes88(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore
Date: 2005-08-12 20:41:57
Message-ID: BAY102-F63B10E3A50E8412DC20B6D1BC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I do a full vacuum and analyze every night, but I'm getting this error.

chived transaction log file "000000010000001200000091"
< % %2005-08-12 06:13:49 EDT>LOG: archived transaction log file
"000000010000001200000092"
< % %2005-08-12 06:13:57 EDT>LOG: archived transaction log file
"000000010000001200000093"
< % %2005-08-12 06:17:51 EDT>LOG: checkpoints are occurring too frequently
(16 seconds apart)
< % %2005-08-12 06:17:51 EDT>HINT: Consider increasing the configuration
parameter "checkpoint_segments".
<postgres %niehs_dev %2005-08-12 06:17:52 EDT>LOG: duration: 2426771.793 ms
statement: VACUUM FULL;

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dirk Kalp 2005-08-12 21:09:06 Re: Trouble Getting Database Server Started
Previous Message Alvaro Herrera 2005-08-12 20:39:35 Re: Log stdout in PG 8?