Re: Problem in restoring data - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Re: Problem in restoring data
Date
Msg-id 3FAEA4F8.1000403@trade-india.com
Whole thread Raw
In response to Re: Problem in restoring data  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general

Yes i may drop the indexes even , but is it quite usual
to take these work arounds in doing major upgrades.

Regds
Mallah.


Alvaro Herrera wrote:
On Mon, Nov 10, 2003 at 01:36:20AM +0530, Rajesh Kumar Mallah wrote:
 
PS: i do not want to edit the (splitted) dump file , my database
is ~ 7 GB   
You can "edit" the dump file by means of
perl -pi -e 's/^CREATE INDEX.*gist.*//' dump-file

or something like that ...
(this isn't a solution to your problem, but may serve as workaround)
 

pgsql-general by date:

Previous
From: so_excited@excite.com (Damon)
Date:
Subject: How to know column constraints via system catalog tables
Next
From: Tom Lane
Date:
Subject: Re: Problem in restoring data