Re: Problem in restoring data

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem in restoring data
Date: 2003-11-08 20:24:15
Message-ID: 20031108202415.GF11397@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Lo esencial es invisible para los ojos" (A. de Saint Exúpery)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-11-08 21:01:25 Re: Problem in restoring data
Previous Message Tom Lane 2003-11-08 19:38:49 Re: int8 primary keys still not using index without manual