Greg Stark wrote:
On Sun, Aug 23, 2009 at 2:18 PM, Jeff Ross<jross@xxxxxxxxxx> wrote:I had to modify your query slightly to make it run--hope I got what you are after! select (h).* from (select heap_page_items(get_raw_page('pg_namespace',0)) as h) as x; http://www.openvistas.net/pageinspect.htmlIncidentally, may as well ask the usual questions: Did you upgrade this via pg_dump/pg_restore or via pg_migrator?
pg_dump
Are you running with fsync=off?
No.
Are you running with synchronous_commit=off?
No.
Have you had any system crashes?
No.
Have you had any Postgres crashes?
No.
Of the above only fsync=off combined with a system crash ought to be unsafe, but it could be good to know which other events have occurred to know which code paths have been exercised. Do you still have pg_clog/0000 (that's kept longer than the xlog so I would expect you would), how large is it? could you send that file? It has a record of which transactions have committed or aborted, no private data.
pg_clog is 32K. I've put it at http://www.openvistas.net/pg_clog Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
