On Fri, Apr 8, 2016 at 11:44 AM, Scott Ribe <scott_r...@elevated-dev.com> wrote:
> Alright, check kernel version, but what else, dump & restore? > > ERROR: unexpected data beyond EOF in block 1 of relation base/16388/35954 > HINT: This has been seen to occur with buggy kernels; consider updating > your system. > > -- > Scott Ribe > scott_r...@elevated-dev.com > http://www.elevated-dev.com/ > https://www.linkedin.com/in/scottribe/ > (303) 722-0567 voice > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > 16388/35954 = DB/object 1.Get the object that is causing the problem: SELECT datname FROM pg_database WHERE oid = 16388; SELECT relname, CASE WHEN relkind = 'r' THEN 'TABLE' WHEN relkind = 'i' THEN 'INDEX' WHEN relkind = 'S' THEN 'SEQUENCE' WHEN relkind = 'v' THEN 'VIEW' WHEN relkind = 'c' THEN 'VIEW' WHEN relkind = 'f' THEN 'Foreign Table' ELSE 'Unknown' END FROM pg_class WHERE relfilenode = 35954; Make sure you have a good backup then: 2. DROP the bad object. 3. RESTORE the object. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
