Re: Database file copy

Srini Raghavan wrote:
> Thank you very much for reviewing, appreciate the feedback.? As pointed out by 
> you, it is always best to test it out with the latest version, so, I tested the 
> same approach with postgres 9.0.2 on windows just now, and it works! 
> 
> 
> I forgot to mention earlier that in addition to setting vacuum_freeze_table_age 
> to 0, vacuum_freeze_min_age must also be set to 0 to reset xmin with the 
> FrozenXid. 

I wonder if you should be using VACUUM FREEZE instead of having to set
variables.      

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +