Hi,
I'm getting inconsistent Postgres errors, when we upgrade our product that
bundles PostgreSQL 9.3.4.
We have 13 databases and we get errors at different places of the database
setup.
Here are the failures:
1.
$POSTGRES/bin/psql -c " CREATE SEQUENCE serial1 START 1 CYCLE ;" -d $ARCHDB
exitIfCommandFailed "Schema creation"
ERROR: index "pg_type_oid_index" contains corrupted page at block 0
HINT: Please REINDEX it.
2.
$POSTGRES/bin/psql -c " CREATE TABLE RAWLOG (ID int8 PRIMARY KEY DEFAULT
nextval('serial1'),SOURCE varchar (100),RAWDATA bytea,WRITETIME timestamp
DEFAULT CURRENT_TIMESTAMP,BOOTTIME timestamp DEFAULT CURRENT_TIMESTAMP
,HIDDEN bool,VERSION int4);" -d $WORKINGDB
ERROR: relation "pg_catalog.pg_database" does not exist
LINE 7: FROM pg_catalog.pg_database d
3.
$POSTGRES/bin/pg_restore -d $EVWEB_DB -p$EVWEB_DB_PORT -U$SFMDB_SU
$VAR_TMP/evwebdump
ERROR: relation "pg_catalog.pg_namespace" does not exist
LINE 3: FROM pg_catalog.pg_namespace n
4.
$POSTGRES/bin/psql -c " CREATE TABLE RAWLOG (ID int8 PRIMARY KEY DEFAULT
nextval('serial1'),SOURCE varchar (100),RAWDATA bytea,WRITETIME timestamp
DEFAULT CURRENT_TIMESTAMP,BOOTTIME timestamp DEFAULT CURRENT_TIMESTAMP
,HIDDEN bool,VERSION int4);" -d $ARCHDB
ERROR: invalid page in block 0 of relation base/216257/11812
All these errors are inconsistent and the errors appear in some other
database, when I repeat the installation.
Any pointers or suggestions are welcome.
On behalf of the Diagnostics team,
Sanjay
