From: | "Rob Long" <rlong(at)micropat(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_restore fails postgres 7.3.4 |
Date: | 2003-10-02 19:48:28 |
Message-ID: | 3F7C810C.4C38778C@micropat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Trying to dump and restore a production database with no success.
pg_dump database using the following:
pg_dump -v -b -C -Fc -U postgres -f servdb.tar.gz servdb
pg_restore with with following:
pg_restore -v -C -D template1 -Fc -U postgres servdb.tar.gz
restore fails with:
pg_restore: [archiver (db)] could not execute query: ERROR: data type
integer has no default operator class for access method "gist"
You must specify an operator class for the index or define a default
operator class for the data type
pg_restore: ***aborted because of error
From the documentation the following query illustrates that I have four
gist acc_methods available:
select am.amname as acc_method, opc.opcname as ops_name
from pg_am am, pg_opclass opc
where opc.opcamid = am.oid
order by acc_method, ops_name;
acc_method | ops_name
-----------------------------
gist | gist_box_ops
gist | gist_int4_ops
gist | gist_poly_ops
gist | gist_timestamp_ops
The create index statement that is failing the restore:
CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc);
Has anyone battled this one before? Is there a problem with
dumping/restoring with blobs?
Thanks,
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Long | 2003-10-02 19:56:13 | pg_restore fails - postgres 7.3.4 |
Previous Message | Chris White (cjwhite) | 2003-10-02 18:39:14 | Question about DB VACUUM |