Re: problem with pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: problem with pg_restore
Date: 2002-01-29 22:36:15
Message-ID: 18461.1012343775@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

s(dot)chava(at)wcom(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lucas Rockwell 2002-01-29 23:51:06 stats for queries
Previous Message Srinivasa Rao Chava 2002-01-29 21:58:06 problem with pg_restore