Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 2B497B5DC69
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  5 Sep 2011 15:09:17 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 90820-01-7
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  5 Sep 2011 18:09:10 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from sam.nabble.com (sam.nabble.com [216.139.236.26])
	by mail.postgresql.org (Postfix) with ESMTP id 20958B5DBC1
	for <pgsql-admin@postgresql.org>; Mon,  5 Sep 2011 15:07:43 -0300 (ADT)
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <marvin.deoliveira@gmail.com>) id 1R0daA-00038A-Oz
	for pgsql-admin@postgresql.org; Mon, 05 Sep 2011 11:07:42 -0700
Date: Mon, 5 Sep 2011 11:07:42 -0700 (PDT)
From: "marvin.deoliveira" <marvin.deoliveira@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1315246062767-4771382.post@n5.nabble.com>
Subject: Can't create a new database from dump
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.767 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01,
	URI_HEX=1.122
X-Spam-Level: 
X-Archive-Number: 201109/15
X-Sequence-Number: 38252


How can I create a entire database from a dump generated with:
./pg_dump -U postgres -F p -E UTF8 -C --inserts --column-inserts -t
<schema.table1> ... -t  <last table>  -v -f dumpfile.sql <database> 

I could not dump the entire database because it has corrupted rows in
pg_attribute.

Need help.



-----
Marcos Oliveira

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Can-t-create-a-new-database-from-dump-tp4771382p4771382.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.