Re: PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief - Mailing list pgsql-novice

From Tom Lane
Subject Re: PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief
Date
Msg-id 17294.1288815700@sss.pgh.pa.us
Whole thread Raw
In response to PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief  (Brian Neu <proclivity76@yahoo.com>)
List pgsql-novice
[ please keep the list cc'd for the archives' sake ]

Brian Neu <proclivity76@yahoo.com> writes:
> Tom, you get gold star for today.  I had it on btrfs, but it was causing a
> kernel crash, so booted in single user mode and moved it to zfs-fuse.

> Wanna to go for 2 gold stars and suggest a solution that doesn't involve me
> reformatting ?

Just change wal_sync_method to whatever will work.  fsync is probably
the lowest common denominator.

            regards, tom lane

pgsql-novice by date:

Previous
From: Brian Neu
Date:
Subject: Re: PANIC: pg_xlog/000blah Invalid argument pg_resetxlog gives no relief
Next
From: lists@kambanaria.org
Date:
Subject: Function to spell out a number