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 65FA3D1B496 for ; Mon, 22 Dec 2003 16:45:15 +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 44505-07 for ; Mon, 22 Dec 2003 12:44:25 -0400 (AST) Received: from web41006.mail.yahoo.com (web41006.mail.yahoo.com [66.218.93.5]) by svr1.postgresql.org (Postfix) with SMTP id 981DED1BC62 for ; Mon, 22 Dec 2003 12:43:52 -0400 (AST) Message-ID: <20031222164352.28683.qmail@web41006.mail.yahoo.com> Received: from [207.98.193.213] by web41006.mail.yahoo.com via HTTP; Mon, 22 Dec 2003 08:43:52 PST Date: Mon, 22 Dec 2003 08:43:52 -0800 (PST) From: Theodore Petrosky Subject: Re: restoring database To: Lucas Lain , pgsql-sql@postgresql.org In-Reply-To: <200312221158.48918.lainl@aconectarse.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/145 X-Sequence-Number: 16311 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. Ted --- Lucas Lain wrote: > Hi everybody ... i need to restore only one database > from a pg_dumpall backup > file... how can i do it? > > Thanks a lot ! > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/