X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 99BEDD1B491 for ; Mon, 22 Dec 2003 18:16:06 +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 58871-08 for ; Mon, 22 Dec 2003 14:15:17 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 97314D1B542 for ; Mon, 22 Dec 2003 14:15:12 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id hBMIB0eD014509; Mon, 22 Dec 2003 11:11:00 -0700 (MST) Date: Mon, 22 Dec 2003 10:53:23 -0700 (MST) From: "scott.marlowe" To: Theodore Petrosky Cc: Lucas Lain , Subject: Re: restoring database In-Reply-To: <20031222164352.28683.qmail@web41006.mail.yahoo.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/146 X-Sequence-Number: 16312 On Mon, 22 Dec 2003, Theodore Petrosky wrote: > As I am not someone with a lot of experience.... > (depending on the size of the 'dumpall') I would > create a new database to suck up the 'all' then > pg_dump the table I really cared about. > > Obviously, if the dump_all is a terabyte database this > method is inconvenient.... (to say the least). > > However it will work. In the past I've used 'cat -n filename'|grep -4 database to find the starting points of individual databases etc... and then used split to break it into the exact right size pieces to do this.