Re: Facing error while restoring the database - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Facing error while restoring the database
Date
Msg-id CAF-3MvNHz++mLvVcp9QG7DyY2s5r2n+R7XkPJYeOvATJdc9stQ@mail.gmail.com
Whole thread Raw
In response to Facing error while restoring the database  (Akshay Joshi <akshay.joshi@enterprisedb.com>)
Responses Re: Facing error while restoring the database
List pgsql-general
On 27 March 2012 11:33, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
> Hi
>
> I am facing issue while restoring the database. I have taken the backup of
> my database using pg_dump and then create new database and try to restore it
> using pg_restore. I am using PostgreSQL 9.0.

What is the error?

It looks like you are trying to use pg_restore on a plain text dump.
In that case, use psql to restore instead.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Janning Vygen
Date:
Subject: PANIC: corrupted item pointer
Next
From: Akshay Joshi
Date:
Subject: Re: Facing error while restoring the database