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 0603ADA689 for ; Thu, 22 Sep 2005 09:26:02 -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 45501-06 for ; Thu, 22 Sep 2005 12:25:57 +0000 (GMT) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.197]) by svr1.postgresql.org (Postfix) with ESMTP id CCB74DA688 for ; Thu, 22 Sep 2005 09:25:57 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id i30so440586wxd for ; Thu, 22 Sep 2005 05:26:01 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=a+OflmvZD57nlXHZQbn/UpP2iiapBn8GJtRMoY/bAbAveQxGbTWsB423qNDeDPm4w7DuErtJKw0FG/kuAhemv4X3KvRQdXdAsfoGWI8/Lqo7Es3Xn53h+LAETXgtmu0Sqcqxf2hjmmjfReCHFmYOZ01uybcZ7Qqv0U41PSwlb3g= Received: by 10.70.60.14 with SMTP id i14mr192827wxa; Thu, 22 Sep 2005 05:26:01 -0700 (PDT) Received: by 10.70.75.4 with HTTP; Thu, 22 Sep 2005 05:26:01 -0700 (PDT) Message-ID: Date: Thu, 22 Sep 2005 17:56:01 +0530 From: Rajesh Kumar Mallah Reply-To: Rajesh Kumar Mallah To: pgsql-admin@postgresql.org Subject: Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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/231 X-Sequence-Number: 18968 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.