On 27 March 2012 11:33, Akshay Joshi <akshay.joshi@xxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general