@@ -1811,9 +1811,10 @@ WaitXLogInsertionsToFinish(XLogRecPtr upto)
1811
1811
*/
1812
1812
if (upto > reservedUpto )
1813
1813
{
1814
- elog (LOG ,"request to flush past end of generated WAL; request %X/%X, currpos %X/%X" ,
1815
- (uint32 ) (upto >>32 ), (uint32 )upto ,
1816
- (uint32 ) (reservedUpto >>32 ), (uint32 )reservedUpto );
1814
+ ereport (LOG ,
1815
+ (errmsg ("request to flush past end of generated WAL; request %X/%X, current position %X/%X" ,
1816
+ (uint32 ) (upto >>32 ), (uint32 )upto ,
1817
+ (uint32 ) (reservedUpto >>32 ), (uint32 )reservedUpto )));
1817
1818
upto = reservedUpto ;
1818
1819
}
1819
1820
@@ -8532,16 +8533,30 @@ ShutdownXLOG(int code, Datum arg)
8532
8533
static void
8533
8534
LogCheckpointStart (int flags ,bool restartpoint )
8534
8535
{
8535
- elog (LOG ,"%s starting:%s%s%s%s%s%s%s%s" ,
8536
- restartpoint ?"restartpoint" :"checkpoint" ,
8537
- (flags & CHECKPOINT_IS_SHUTDOWN ) ?" shutdown" :"" ,
8538
- (flags & CHECKPOINT_END_OF_RECOVERY ) ?" end-of-recovery" :"" ,
8539
- (flags & CHECKPOINT_IMMEDIATE ) ?" immediate" :"" ,
8540
- (flags & CHECKPOINT_FORCE ) ?" force" :"" ,
8541
- (flags & CHECKPOINT_WAIT ) ?" wait" :"" ,
8542
- (flags & CHECKPOINT_CAUSE_XLOG ) ?" wal" :"" ,
8543
- (flags & CHECKPOINT_CAUSE_TIME ) ?" time" :"" ,
8544
- (flags & CHECKPOINT_FLUSH_ALL ) ?" flush-all" :"" );
8536
+ if (restartpoint )
8537
+ ereport (LOG ,
8538
+ /* translator: the placeholders show checkpoint options */
8539
+ (errmsg ("restartpoint starting:%s%s%s%s%s%s%s%s" ,
8540
+ (flags & CHECKPOINT_IS_SHUTDOWN ) ?" shutdown" :"" ,
8541
+ (flags & CHECKPOINT_END_OF_RECOVERY ) ?" end-of-recovery" :"" ,
8542
+ (flags & CHECKPOINT_IMMEDIATE ) ?" immediate" :"" ,
8543
+ (flags & CHECKPOINT_FORCE ) ?" force" :"" ,
8544
+ (flags & CHECKPOINT_WAIT ) ?" wait" :"" ,
8545
+ (flags & CHECKPOINT_CAUSE_XLOG ) ?" wal" :"" ,
8546
+ (flags & CHECKPOINT_CAUSE_TIME ) ?" time" :"" ,
8547
+ (flags & CHECKPOINT_FLUSH_ALL ) ?" flush-all" :"" )));
8548
+ else
8549
+ ereport (LOG ,
8550
+ /* translator: the placeholders show checkpoint options */
8551
+ (errmsg ("checkpoint starting:%s%s%s%s%s%s%s%s" ,
8552
+ (flags & CHECKPOINT_IS_SHUTDOWN ) ?" shutdown" :"" ,
8553
+ (flags & CHECKPOINT_END_OF_RECOVERY ) ?" end-of-recovery" :"" ,
8554
+ (flags & CHECKPOINT_IMMEDIATE ) ?" immediate" :"" ,
8555
+ (flags & CHECKPOINT_FORCE ) ?" force" :"" ,
8556
+ (flags & CHECKPOINT_WAIT ) ?" wait" :"" ,
8557
+ (flags & CHECKPOINT_CAUSE_XLOG ) ?" wal" :"" ,
8558
+ (flags & CHECKPOINT_CAUSE_TIME ) ?" time" :"" ,
8559
+ (flags & CHECKPOINT_FLUSH_ALL ) ?" flush-all" :"" )));
8545
8560
}
8546
8561
8547
8562
/*
@@ -8591,25 +8606,46 @@ LogCheckpointEnd(bool restartpoint)
8591
8606
CheckpointStats .ckpt_sync_rels ;
8592
8607
average_msecs = (long ) ((average_sync_time + 999 ) /1000 );
8593
8608
8594
- elog (LOG ,"%s complete: wrote %d buffers (%.1f%%); "
8595
- "%d WAL file(s) added, %d removed, %d recycled; "
8596
- "write=%ld.%03d s, sync=%ld.%03d s, total=%ld.%03d s; "
8597
- "sync files=%d, longest=%ld.%03d s, average=%ld.%03d s; "
8598
- "distance=%d kB, estimate=%d kB" ,
8599
- restartpoint ?"restartpoint" :"checkpoint" ,
8600
- CheckpointStats .ckpt_bufs_written ,
8601
- (double )CheckpointStats .ckpt_bufs_written * 100 /NBuffers ,
8602
- CheckpointStats .ckpt_segs_added ,
8603
- CheckpointStats .ckpt_segs_removed ,
8604
- CheckpointStats .ckpt_segs_recycled ,
8605
- write_msecs /1000 , (int ) (write_msecs %1000 ),
8606
- sync_msecs /1000 , (int ) (sync_msecs %1000 ),
8607
- total_msecs /1000 , (int ) (total_msecs %1000 ),
8608
- CheckpointStats .ckpt_sync_rels ,
8609
- longest_msecs /1000 , (int ) (longest_msecs %1000 ),
8610
- average_msecs /1000 , (int ) (average_msecs %1000 ),
8611
- (int ) (PrevCheckPointDistance /1024.0 ),
8612
- (int ) (CheckPointDistanceEstimate /1024.0 ));
8609
+ if (restartpoint )
8610
+ ereport (LOG ,
8611
+ (errmsg ("restartpoint complete: wrote %d buffers (%.1f%%); "
8612
+ "%d WAL file(s) added, %d removed, %d recycled; "
8613
+ "write=%ld.%03d s, sync=%ld.%03d s, total=%ld.%03d s; "
8614
+ "sync files=%d, longest=%ld.%03d s, average=%ld.%03d s; "
8615
+ "distance=%d kB, estimate=%d kB" ,
8616
+ CheckpointStats .ckpt_bufs_written ,
8617
+ (double )CheckpointStats .ckpt_bufs_written * 100 /NBuffers ,
8618
+ CheckpointStats .ckpt_segs_added ,
8619
+ CheckpointStats .ckpt_segs_removed ,
8620
+ CheckpointStats .ckpt_segs_recycled ,
8621
+ write_msecs /1000 , (int ) (write_msecs %1000 ),
8622
+ sync_msecs /1000 , (int ) (sync_msecs %1000 ),
8623
+ total_msecs /1000 , (int ) (total_msecs %1000 ),
8624
+ CheckpointStats .ckpt_sync_rels ,
8625
+ longest_msecs /1000 , (int ) (longest_msecs %1000 ),
8626
+ average_msecs /1000 , (int ) (average_msecs %1000 ),
8627
+ (int ) (PrevCheckPointDistance /1024.0 ),
8628
+ (int ) (CheckPointDistanceEstimate /1024.0 ))));
8629
+ else
8630
+ ereport (LOG ,
8631
+ (errmsg ("checkpoint complete: wrote %d buffers (%.1f%%); "
8632
+ "%d WAL file(s) added, %d removed, %d recycled; "
8633
+ "write=%ld.%03d s, sync=%ld.%03d s, total=%ld.%03d s; "
8634
+ "sync files=%d, longest=%ld.%03d s, average=%ld.%03d s; "
8635
+ "distance=%d kB, estimate=%d kB" ,
8636
+ CheckpointStats .ckpt_bufs_written ,
8637
+ (double )CheckpointStats .ckpt_bufs_written * 100 /NBuffers ,
8638
+ CheckpointStats .ckpt_segs_added ,
8639
+ CheckpointStats .ckpt_segs_removed ,
8640
+ CheckpointStats .ckpt_segs_recycled ,
8641
+ write_msecs /1000 , (int ) (write_msecs %1000 ),
8642
+ sync_msecs /1000 , (int ) (sync_msecs %1000 ),
8643
+ total_msecs /1000 , (int ) (total_msecs %1000 ),
8644
+ CheckpointStats .ckpt_sync_rels ,
8645
+ longest_msecs /1000 , (int ) (longest_msecs %1000 ),
8646
+ average_msecs /1000 , (int ) (average_msecs %1000 ),
8647
+ (int ) (PrevCheckPointDistance /1024.0 ),
8648
+ (int ) (CheckPointDistanceEstimate /1024.0 ))));
8613
8649
}
8614
8650
8615
8651
/*