X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DC728D1E150 for ; Fri, 20 Feb 2004 12:14:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 44994-06 for ; Fri, 20 Feb 2004 08:14:44 -0400 (AST) Received: from fep02-mail.bloor.is.net.cable.rogers.com (fep02-mail.bloor.is.net.cable.rogers.com [66.185.86.72]) by svr1.postgresql.org (Postfix) with ESMTP id C7985D1D570 for ; Fri, 20 Feb 2004 08:14:40 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep02-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040220121423.HMES181170.fep02-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Fri, 20 Feb 2004 07:14:23 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id AF2603F40; Fri, 20 Feb 2004 07:14:42 -0500 (EST) Date: Fri, 20 Feb 2004 07:14:42 -0500 From: Andrew Sullivan To: PGSQL Subject: Re: pg_restore - don?t restore. Why? Message-ID: <20040220121442.GA15383@phlogiston.dyndns.org> Mail-Followup-To: PGSQL References: <001e01c3f761$187b2d80$cade92c8@info2000.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <001e01c3f761$187b2d80$cade92c8@info2000.com.br> User-Agent: Mutt/1.5.4i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep02-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Fri, 20 Feb 2004 07:14:23 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/301 X-Sequence-Number: 16991 On Fri, Feb 20, 2004 at 12:24:46AM -0300, 2000info wrote: > pg_dump, ok. > pg_restore, don?t restore. Why? If you didn't use a non-ASCII format from pg_dump, you don't need pg_restore. Just use psql. A -- Andrew Sullivan