can't duplicate an error in a restored DB - Mailing list pgsql-general

From Stefan Murphy
Subject can't duplicate an error in a restored DB
Date
Msg-id cf748ad90901221101h66204cces63043cc0364bbfa5@mail.gmail.com
Whole thread Raw
List pgsql-general
Postgres 8.1.11

I'm getting an error when trying to drop a primary key from a table
because of foreign key constraints.  This is OK, not worried about
that.  I am worried that I can't duplicate the problem in a DB created
from a backup of my primary DB.

The error happens in my primary production database.  However, I can't
duplicate the problem on a DB that has been restored from a dump of
the production DB.  I even took my production WAL DB out of standby,
backed it up, recreated the error, restored from the backup I just
made and can no longer recreate the error.

My question: Am I doing something wrong in how I backup and restore a
DB?  Or is there something else going on here?

How I'm dumping/restoring the db below.  There is just the default
postgres DB and my DB named hdap.

linux: pg_dumpall -p 6543 > backup.file
psql: drop database hdap
linux: psql -f backup.file

Below is the ERROR that I can't duplicate in restored DB.

Production
db2/[local] hdap=# ALTER TABLE device.device_types DROP CONSTRAINT
"device_types_pkey" CASCADE;
ALTER TABLE device.device_types DROP CONSTRAINT "device_types_pkey" CASCADE;
NOTICE:  drop cascades to constraint
device_kit_type_members_device_type_id_fkey on table
device.device_kit_type_members
ERROR:  "device_kit_type_members_pkey" is an index

DB created Production pg_dumpall
db6/[local] hdap=# ALTER TABLE device.device_types DROP CONSTRAINT
"device_types_pkey" CASCADE;
ALTER TABLE device.device_types DROP CONSTRAINT "device_types_pkey" CASCADE;
NOTICE:  drop cascades to constraint devices_device_type_id_fkey on
table device.devices
NOTICE:  drop cascades to constraint
device_type_properties_device_type_id_fkey on table
device.device_type_properties
NOTICE:  drop cascades to constraint
device_kit_type_members_device_type_id_fkey on table
device.device_kit_type_members
ALTER TABLE

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: difference between current_timestamp and now() in quotes
Next
From: Scott Marlowe
Date:
Subject: Re: How to find how much postgresql use the memory?