| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Srini Raghavan <sixersrini(at)yahoo(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Database file copy |
| Date: | 2011-01-13 03:05:53 |
| Message-ID: | 201101130305.p0D35rG07349@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2011-01-13 03:12:48 | Re: pg_regress multibyte setting |
| Previous Message | Itagaki Takahiro | 2011-01-13 02:52:47 | Re: pg_regress multibyte setting |