I have a transaction ID wrapper around related problem:
Does vacuum freeze only need to be done when initdb? is it a one time thing, only do it once??? no more??
in my system, when I use
select datname, age(datfrozenxid) from pg_database;
I get the following data:
I'm worried about the age for template0, I would think when initdb, template0 has already been vacuum freezed,
the datallowconn for template0 is set to false, we cannot connect template0. If the age for template0 keep going up,
will it meet transaction ID wrapper around problem??? Is one more vacuum freeze on template0 needed???
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2007-03-01 15:26:00|
|Subject: Re: postgres 8.1.8 transaction ID wrapper around related problem |
|Previous:||From: Peter K. Stys||Date: 2007-02-28 21:47:08|
|Subject: libpq.a and Xcode on Mac OS X|