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
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 |