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 0EBEAD83EF for ; Thu, 22 Sep 2005 06:14:51 -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 98580-02 for ; Thu, 22 Sep 2005 09:14:47 +0000 (GMT) Received: from trade-india.com (infocom-82-154-16-del.trade-india.com [61.16.154.82]) by svr1.postgresql.org (Postfix) with SMTP id E3F97D81CE for ; Thu, 22 Sep 2005 06:14:44 -0300 (ADT) Received: (qmail 9904 invoked from network); 22 Sep 2005 08:52:31 -0000 Received: from unknown (HELO ?192.168.0.100?) (192.168.0.100) by 192.168.0.66 with SMTP; 22 Sep 2005 08:52:31 -0000 Message-ID: <433275EA.9000604@tradeindia.com> Date: Thu, 22 Sep 2005 14:44:18 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050727) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgres Admin List Subject: Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/252 X-Sequence-Number: 18989 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 ? Regds Mallah.