On 05/31/2011 10:46 PM, Mathew Samuel wrote:
Thanks for your help, here are the results from running that you provided to me:
$ egrep '^[^#[:space:]]' postgresql.conf |cut -d '#' -f 1
[snip]
OK, nothing interesting there. Thanks for posting it, though; I was
wondering if there might be a very
Craig Ringer writes:
> On 05/30/2011 10:29 PM, Mathew Samuel wrote:
>
>> 2011-03-28 10:44:28 UTC3609HINT: Consider increasing the configuration
>> parameter "checkpoint_segments".
>> 2011-03-28 10:44:38 UTC3609LOG: checkpoints are occurring too
>> frequently (10 seconds apart)
>> 2011-03-28 10:
Craig Ringer writes:
> On 05/30/2011 10:29 PM, Mathew Samuel wrote:
>> 2011-03-28 10:44:42 UTC3932ERROR: canceling statement due to statement
>> timeout
>> 2011-03-28 10:44:42 UTC3932STATEMENT: vacuum full analyze _zamboni.sl_log_1
>> 2011-03-28 10:44:42 UTC3932PANIC: cannot abort transaction 1827
On 05/30/2011 10:29 PM, Mathew Samuel wrote:
2011-03-28 10:44:28 UTC3609HINT: Consider increasing the configuration
parameter "checkpoint_segments".
2011-03-28 10:44:38 UTC3609LOG: checkpoints are occurring too frequently
(10 seconds apart)
2011-03-28 10:44:38 UTC3609HINT: Consider increasing th
Hi,
I see the following error as found in pg.log:
UTC4115FATAL: the database system is in recovery mode
Actually that message was logged repeatedly for about 4 hours according to the
logs (I don't have access to the system itself, just the logs).
Leading up to that error were the following in
