Re: pg_restore - Mailing list pgsql-admin

From D Kavan
Subject Re: pg_restore
Date
Msg-id BAY102-F63B10E3A50E8412DC20B6D1BC0@phx.gbl
Whole thread Raw
In response to Re: pg_restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_restore  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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;



pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Log stdout in PG 8?
Next
From: "Dirk Kalp"
Date:
Subject: Re: Trouble Getting Database Server Started