Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems doing a restore under 7.4.2 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problems doing a restore under 7.4.2
Date
Msg-id 19432.1082606525@sss.pgh.pa.us
Whole thread Raw
In response to Problems doing a restore under 7.4.2  ("Chris White (cjwhite)" <cjwhite@cisco.com>)
Responses Re: Problems doing a restore under 7.4.2
List pgsql-admin
Tree view 
"Chris White (cjwhite)" <cjwhite@cisco.com> writes:
> I have done a backup of my 7.4.2 database using pg_dump. When I restore
> the database using the -c option I get the following error message and
> pg_restore fails

> pg_restore: [archiver (db)] could not execute query: ERROR: trigger
> "RI_ConstraintTrigger_17371" for table "vm_message" does not exist

Probably an ordering issue --- easiest workaround is not to use -c,
I'd think.

If you like, you could try CVS-tip pg_dump to see if it gets the
ordering right.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: set_curcfg('default') + tsearch1 call = postmaster crash
Next
From: "Chris White (cjwhite)"
Date:
Subject: Re: Problems doing a restore under 7.4.2