Horton

Re: Database file copy

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: Srini Raghavan <sixersrini@yahoo.com>
Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-01-13T03:05:53Z
Lists: pgsql-hackers 
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. +