Idea ID 1643146
pgstat.tmp file should be excluded during IDB backup , or we should be able to disable the Statistics Collector as long as DP doesn't use Collected Statistics .
Benefits / Value
The following warning message often appears during IDB backup .
[Warning] From: OB2BAR_POSTGRES_BAR@<hostname> "DPIDB" Time: 2018/02/09 19:02:20
A non-essential file cannot be found, backup continues
According to debugs , the file is pgstat.tmp that is created by the Statistics Collector of Postgres .
[ 4] 2018-02-09 19:02:20.792 ("/integ/bar2/ob2dma.c $Rev: 48111 $ $Date:: 2015-05-05 10:51:39":890)
[ 4] [MARK 2] in OB2_StatFile:890
Code: 1026 SystemErr:  The system cannot find the file specified.
Because it is hard to confirm what kind of files could not be backed up without debugs, it should be reasonable to exclude pgstat.tmp to reduce the message occurrences .
To exclude pgstat.tmp file during IDB backup , an implementation is needed in OB2BAR_POSTGRES_BAR .
The Statistics Collector can be disabled by modifying postgresql.conf file .
NOTE : I have duplicated this request from QCCR2A79020 as this is the new place to submit ERs .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.