On 11/13/2016 11:52 PM, Yogesh Sharma wrote:
you can look those relation numbers up in the pg_catalog to see what they are. you can see what the processes are in pg_stat_activity.
Currently machine is not available. Please suggest if any other approach to identify the same.
without access to the system thats generating the error, there's nothing you can learn.
>THis has nothing to do with the growing WAL logs... something is blocking checkpoints if a single WAL file keeps >growing, are you using some form of wal archiving, is that working correctly ? could something
>be preventing checkpoints? what are the related checkpoint and WAL settings?
Many WAL files are generated in pg_xlog directory. I don’t know how I can check checkpoint and WAL settings?
By default setting of postgresql.conf is used.
I just noticed, you're talking about postgresql 8.1.18? thats an unsupported and obsolete version from 2009.
A standalone postgres installation that hasn't been configured for WAL archiving will normally only generate up to 2*CHECKPOINT_SEGMENTS + 1 wal files of 16MB each (assuming all defaults, thats 7 files). The obsolete 8.1 documentation on this is here, https://www.postgresql.org/docs/8.1/static/wal-configuration.html
If you've configured wal archiving, AND this isn't working correctly, WAL files can stack up indefinitely. See https://www.postgresql.org/docs/8.1/static/backup-online.html
--
john r pierce, recycling bits in santa cruz
