Kristaps Armanis <krisha@xxxxxxxxxx> writes: > Is there any solution? I think what you have to do is use pg_resetxlog with -x and a value just shy of 2^32. then pg_dump and restore into a fresh database. I've never done it though so perhaps you should wait until someone with more experience speaks up. I would also suggest taking a cold backup of the bad database before running pg_resetxlog. -- greg ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
