On Wed, Dec 28, 2011 at 5:34 PM, Yi Lu <y...@ramsoft.biz> wrote: > It is feasible to roll over the transaction ID without putting the database > offline? i.e. when ID is close to limit, reset it to 0 from the code?
Seems that PostgreSQL AutoVacuum daemon do that for Postgresql databases : http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html "PostgreSQL's VACUUM command has to run on a regular basis for several reasons: ... To protect against loss of very old data due to transaction ID wraparound" ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
