Re: transaction wrap around

John R Pierce <pierce@hogranch.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