Re: problem with pg_restore - Mailing list pgsql-admin

From Tom Lane
Subject Re: problem with pg_restore
Date
Msg-id 18461.1012343775@sss.pgh.pa.us
Whole thread Raw
In response to problem with pg_restore  (s.chava@wcom.com (Srinivasa Rao Chava))
List pgsql-admin
s.chava@wcom.com (Srinivasa Rao Chava) writes:
> I have a problem with pg_restore. I have a database,  named DEPG. I
> have taken backup with pg_dump and -Ft options. I created  another
> database, named test. After this , I used the pg_restore command  to
> restore the DEPG backup into test database. Then it is restoring upto
> some point and failing giving the following error.

You need to update to 7.1.3; earlier 7.1.* pg_dumps have a problem with
the ordering of commands for GRANTs on views.

            regards, tom lane

pgsql-admin by date:

Previous
From: s.chava@wcom.com (Srinivasa Rao Chava)
Date:
Subject: problem with pg_restore
Next
From: Lucas Rockwell
Date:
Subject: stats for queries