pg_dump problem...

From: "Andrew W(dot) Schmeder" <andy(at)e-molecule(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump problem...
Date: 2001-06-11 22:12:58
Message-ID: 61772.63.141.165.131.992297578.squirrel@secure.e-molecule.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi.

I am having a problem with the dump/restore operating for a 7.0.2 -> 7.1.2 migration.

This database won't let me do an export...

../bin/pg_dump xapnet_web
PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
Segmentation fault

The nightly backup script for this database has been reporting this error for some time:

NOTICE: Index pg_attribute_relid_attnum_index: NUMBER OF INDEX' TUPLES (725) IS NOT THE SAME AS
HEAP' (958).
Recreate the index.
NOTICE: Index pg_index_indexrelid_index: NUMBER OF INDEX' TUPLES (86) IS NOT THE SAME AS HEAP'
(85).
Recreate the index.

The database seems to behave normally during all interactions via sql. The database is not large
(less than 1 megabyte).

Is there anything I can do...? Maybe some other method for exporting the data?

later,
andy
--
Andrew W. Schmeder
andy(at)electronicmolecule(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-06-11 22:15:16 Re: What the heck is happening here?
Previous Message Christopher Zach 2001-06-11 22:05:57 rtree index very large