how about 4.3.2?
I have gcc 4.3.2 compiled postgresql 9.0.4 as slave, is that okay
that I turn the slave into master? so the switch will be a lot more
smooth.
On Tue, Jul 26, 2011 at 12:08 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Yan Chunlu <springrider@gmail.com> writes:
>> oh god...thanks a lot for the tip. I did actually lost some data, the
>> master server has crashed two times. every time it comes back, the
>> index were broken. I need to reindex it. I have already set fsync=on.
>> just thought it was normal behavior....
>
> Uh, no.
>
>> about gcc version, only 4.6.0 effected? 4.6.1 is okay? then I could
>> compile my own version with 4.6.1
>
> It's supposed to be fixed in 4.6.1 according to
> http://gcc.gnu.org/bugzilla/show_bug.cgi?id=49390
>
> Personally I'd use 4.6.1 *and* apply the Postgres patch.
>
> regards, tom lane
>