Hello,
I was trying to figure out how does one recover server statistics to the same snapshot to which a database is restored after PITR.
The steps i had in mind were
1.Set up WAL archiving
2.On server shutdown one would need to backup pg_stat_tmp along with file system level back of database
3. On server crash setup configuration for recovery mode
4. Restart server, which replays WAL files and hen moves from recovery to normal mode
What will be behavior be regarding pg_stat_tmp? Will it be deleted on startup? Is it possible to recover the same statistics as on last server shutdown? ICan the statistics recovered to the same PITR?
Thank you
Sameer