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: [archi
"Rob Long" <[EMAIL PROTECTED]> writes:
> Will this be fixed in 7.4?
Yes, and also in 7.3.5 if there is such a release.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
htt
Tom,
Will this be fixed in 7.4?
Thanks for the support.
Rob
- Original Message -
From: Tom Lane <[EMAIL PROTECTED]>
Date: Thursday, October 2, 2003 6:28 pm
Subject: Re: [ADMIN] pg_restore fails - postgres 7.3.4
> "Rob Long" <[EMAIL PROTECTED]> writes:
> &g
"Rob Long" <[EMAIL PROTECTED]> writes:
>>> Trying to dump and restore a production database with no success.
>>>
>>> pg_restore: [archiver (db)] could not execute query: ERROR: data type
>>> integer has no default operator class for access method "gist"
>>
>> Hm, this is probably a matter of inco
Attached.
The previously posted index failure stated:
CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc);
However in this list it is:
CREATE INDEX idx_item_loc ON content_items USING gist (disclosuer, loc);
Rob
Tom Lane wrote:
> "Rob Long" <[EMAIL PROTECTED]> writes:
> > Trying to
"Rob Long" <[EMAIL PROTECTED]> writes:
> Trying to dump and restore a production database with no success.
> pg_restore: [archiver (db)] could not execute query: ERROR: data type
> integer has no default operator class for access method "gist"
Hm, this is probably a matter of incorrect object res
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: [archi
