pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres 8.1.8 transaction ID wrapper around related problem
2+ messages / 2 participants
[nested] [flat]
* postgres 8.1.8 transaction ID wrapper around related problem
@ 2007-03-01 14:59 jing han <jing_han_66@yahoo.com>
2007-03-01 15:26 ` Re: postgres 8.1.8 transaction ID wrapper around related problem Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: jing han @ 2007-03-01 14:59 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
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:
datname age
postgres 2075973034
netman 2117293144
template1 1795797763
template0 2075973034
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???
jing
____________________________________________________________________________________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: postgres 8.1.8 transaction ID wrapper around related problem
2007-03-01 14:59 postgres 8.1.8 transaction ID wrapper around related problem jing han <jing_han_66@yahoo.com>
@ 2007-03-01 15:26 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-03-01 15:26 UTC (permalink / raw)
To: jing han <jing_han_66@yahoo.com>; +Cc: pgsql-interfaces
jing han <jing_han_66@yahoo.com> writes:
> I'm worried about the age for template0,
Don't worry about it. template0 was frozen when it was made, there's no
need for any vacuuming of it.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-03-01 15:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-01 14:59 postgres 8.1.8 transaction ID wrapper around related problem jing han <jing_han_66@yahoo.com>
2007-03-01 15:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox