X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 14F86D921C for ; Fri, 23 Sep 2005 20:49:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18666-02 for ; Fri, 23 Sep 2005 23:49:19 +0000 (GMT) Received: from eastrmmtao04.cox.net (eastrmmtao04.cox.net [68.230.240.35]) by svr1.postgresql.org (Postfix) with ESMTP id 3F5EAD91B9 for ; Fri, 23 Sep 2005 20:49:20 -0300 (ADT) Received: from [192.168.0.17] (really [68.105.164.251]) by eastrmmtao04.cox.net (InterMail vM.6.01.05.02 201-2131-123-102-20050715) with ESMTP id <20050923234923.NZWK14217.eastrmmtao04.cox.net@[192.168.0.17]>; Fri, 23 Sep 2005 19:49:23 -0400 From: Robert Treat To: pgsql-admin@postgresql.org Subject: Re: Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ? Date: Fri, 23 Sep 2005 19:49:23 -0400 User-Agent: KMail/1.6.2 Cc: Rajesh Kumar Mallah References: <433275EA.9000604@tradeindia.com> In-Reply-To: <433275EA.9000604@tradeindia.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200509231949.23261.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.037 required=5 tests=[AWL=0.037] X-Spam-Level: X-Archive-Number: 200509/277 X-Sequence-Number: 19014 On Thursday 22 September 2005 05:14, Rajesh Kumar Mallah wrote: > Hi , > > I suppose pgdump_all creates a SQL script > that is capable of recreating the entire database > except for large_objects. > > However pgdump_all produces one single large > SQL files and is not useful(easy) if one has to restore > a particular table. > > For this reason we backup our databases individually > using custom format and use pg_restore to restore > individual objects as when required. > > My doubt is are the individual database backup files > created through -Fc options along with an SQL file > created using "pgdump_all -g " sufficient to recreate > the entire database ? > Assuming your version of pg_dump dumps binary data with an -Fc dump, then yes. (Check the docs if you want to verify) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL