Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0TMaFl69901 for ; Tue, 29 Jan 2002 17:36:15 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g0TMaFf18464; Tue, 29 Jan 2002 17:36:16 -0500 (EST) To: s.chava@wcom.com (Srinivasa Rao Chava) cc: pgsql-admin@postgresql.org Subject: Re: problem with pg_restore In-reply-to: <66d229f1.0201291358.2292b7c9@posting.google.com> References: <66d229f1.0201291358.2292b7c9@posting.google.com> Comments: In-reply-to s.chava@wcom.com (Srinivasa Rao Chava) message dated "29 Jan 2002 13:58:06 -0800" Date: Tue, 29 Jan 2002 17:36:15 -0500 Message-ID: <18461.1012343775@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200201/249 X-Sequence-Number: 3130 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