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