X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id EF45ED1C4C1 for ; Tue, 22 Jul 2003 21:05:59 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 90713-06 for ; Tue, 22 Jul 2003 18:05:15 -0300 (ADT) Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by svr1.postgresql.org (Postfix) with ESMTP id 13AC5D1C4DC for ; Tue, 22 Jul 2003 18:05:58 -0300 (ADT) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.12.3/8.12.3/Debian-6.4) with SMTP id h6ML5x0P013392; Tue, 22 Jul 2003 16:06:00 -0500 Reply-To: From: "Nick Fankhauser" To: "David Olbersen" , Subject: Re: pg_restore problem!!! Date: Tue, 22 Jul 2003 16:04:31 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=IN_REP_TO, MSGID_GOOD_EXCHANGE, PLING_PLING, QUOTED_EMAIL_TEXT X-Spam-Level: X-Archive-Number: 200307/224 X-Sequence-Number: 9564 > To nit-pick, this is a "useless use of cat". > > In UNIX-land, simple input redirection will work much better: > > psql [dbname and various options] < [filename] Good point... to elaborate further, the reason I was in a piping mindset is that with a large database, it also makes sense to compress on the fly to avoid filesystem size limits, so I usually use this pair of commands for backup/restore: pg_dump dbname | gzip > dbdumpfile.gz gunzip -c dbdumpfile | psql dbname -Nick