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 C9BD5D1B4A6 for ; Tue, 23 Dec 2003 10:19:49 +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 65937-06 for ; Tue, 23 Dec 2003 06:19:02 -0400 (AST) Received: from yarrow.bertheau.de (dsl-213-023-155-213.arcor-ip.net [213.23.155.213]) by svr1.postgresql.org (Postfix) with ESMTP id 832E5D1B49E for ; Tue, 23 Dec 2003 06:18:43 -0400 (AST) Received: from yarrow.bertheau.de (yarrow.bertheau.de [127.0.0.1]) by yarrow.bertheau.de (8.12.10/8.12.10) with ESMTP id hBNAIIr6005281; Tue, 23 Dec 2003 11:18:18 +0100 Received: (from bert@localhost) by yarrow.bertheau.de (8.12.10/8.12.10/Submit) id hBNAIH37005279; Tue, 23 Dec 2003 11:18:17 +0100 X-Authentication-Warning: yarrow.bertheau.de: bert set sender to twanger@bluetwanger.de using -f Subject: Re: restoring database From: Markus Bertheau To: "scott.marlowe" Cc: Theodore Petrosky , Lucas Lain , pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1072174696.4901.0.camel@yarrow.bertheau.de> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Tue, 23 Dec 2003 11:18:17 +0100 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/163 X-Sequence-Number: 16329 =D0=92 =D0=9F=D0=BD=D0=B4, 22.12.2003, =D0=B2 18:53, scott.marlowe =D0=BF= =D0=B8=D1=88=D0=B5=D1=82: > On Mon, 22 Dec 2003, Theodore Petrosky wrote: >=20 > > 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.=20 > >=20 > > Obviously, if the dump_all is a terabyte database this > > method is inconvenient.... (to say the least). > >=20 > > However it will work. >=20 > In the past I've used=20 >=20 > 'cat -n filename'|grep -4 database >=20 > to find the starting points of individual databases etc... and then used= =20 > split to break it into the exact right size pieces to do this. That sounds like something pg_dump / pg_dumpall should be able to do itself, don't you think? --=20 Markus Bertheau