On 27 March 2012 11:33, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)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.