Evan Walter <ewalter@xxxxxxxxxxxxxxxxxxx> writes: > Thanks for the replies, sorry for not giving more details/background. > The directory is global/26745 OK, so try select relname from pg_class where relisshared and pg_relation_filenode(oid) = 26745; That should tell you which table or index is busted. > It is version 9.1.9 > os is ubuntu on an Amazon ec2 server Um. AWS is, AFAIK, pretty much guaranteed to lose your data eventually. It's a great compute service if you can afford to have nodes fail now and then ... but probably not the best substrate for a database. If you have to use it for that, you *must* have good backup and replication strategies in place. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
