On Wednesday 5. October 2011 20.42.00 Tom Lane wrote: > Postgres can't magically resurrect data that your drive lost, if that's > what you were hoping for. However, you might be in luck, because that > file is probably just an index and not original data. Try this: > > select relname from pg_class where relfilenode = 11658; > > On my 9.0 installation I get "pg_opclass_am_name_nsp_index". If you get > the same (or any other index for that matter) just reindex that index > and you'll be all right ... or at least, you will be if that's the only > file your drive has lost.
Tom, this is what I get: postgres@balapapa ~ $ psql pgslekt psql (9.0.5) Type "help" for help. pgslekt=# select relname from pg_class where relfilenode = 11658; relname ------------- pg_opfamily (1 row) regards, Leif -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
