John R Pierce <pierce(at)hogranch(dot)com> writes:
> On 12/4/2017 2:21 PM, chris kim wrote:
>> How would I investigate if my database is nearing a transaction wrap
>> around.
> it would be screaming bloody murder in the log, for one.
I think the simplest thing is to keep an eye on
select max(age(datfrozenxid)) from pg_database;
If that starts to approach two billion, or gets a lot larger than
autovacuum_freeze_max_age, you've got a problem.
regards, tom lane