Postgres error while running SELECT Query

Question

When running select query i am getting below error. I am new to postgres and need your suggestions on this.

ERROR: could not seek to end of segment 0 of relation pg_table1/23111/191232/112333: Input/output error

Please suggest what could be the reasons.

More details would be appreciated... Table structure, request... — Fred
– Fred, Commented Dec 2, 2011 at 15:48
What version of Postgres are you running? Please post full logs if possible. — Chris Cashwell
– Chris Cashwell, Commented Dec 2, 2011 at 15:50
I dont have much information about table str, etc. Postgres version is 8.4.7 — Space
– Space, Commented Dec 2, 2011 at 16:01

Kuberchaun · Accepted Answer · 2011-12-02 16:35:25Z

1

Messages like that are typically signs of some kind of corruption. This link touches on some similar things. Stark Presentation

answered Dec 2, 2011 at 16:35

Kuberchaun

30.5k8 gold badges54 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Richard Huxton Over a year ago

Yes, the requests for more information are missing the point. You have corrupt database files due to one of: 1. disk errors 2. operating-system / vm bugs 3. crashes while disks weren't respecting fsync or similar The thing to do is shut down postgresql, take a backup of all the files (including WAL) and see what you can recover. If you have a recent backup, just restore from that - it'll be quicker. Then, find out what's broken on your system - it's unlikely to be PostgreSQL corrupting your data unless you've been hacking on it yourself.

Collectives™ on Stack Overflow

Postgres error while running SELECT Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related