X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ABC9F56661 for ; Tue, 1 Mar 2005 08:27:18 +0000 (GMT) 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 62795-09 for ; Tue, 1 Mar 2005 08:27:16 +0000 (GMT) Received: from vas.3wsi.net (unknown [202.81.37.24]) by svr1.postgresql.org (Postfix) with SMTP id E176D5661B for ; Tue, 1 Mar 2005 08:27:11 +0000 (GMT) Received: (qmail 17541 invoked by uid 1018); 1 Mar 2005 08:27:05 -0000 Received: from 202.81.37.29 by vas.3wsi.net (envelope-from , uid 64011) with qmail-scanner-1.25 (clamdscan: 0.81/708. sophie: 3.04/2.28/3.90. Clear:RC:1(202.81.37.29):. Processed in 0.084313 secs); 01 Mar 2005 08:27:05 -0000 Received: from unknown (HELO richard) (202.81.37.29) by 0 with SMTP; 1 Mar 2005 08:27:05 -0000 From: "Richard Sitompul" To: "'PgSQL Admin'" Subject: Re: Whats the file extention for custom format in pg_dump Date: Tue, 1 Mar 2005 15:33:10 +0700 Message-ID: <000101c51e39$4d74b330$1d2551ca@richard> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 Importance: Normal In-Reply-To: <674d1f8a050228233771b8326b@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/3 X-Sequence-Number: 16501 You can try pg_dump -U postgres -d -O databasename > databasename.sql Thanks, Richard Sitompul -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Gourish Singbal Sent: Tuesday, March 01, 2005 14:37 To: PgSQL Admin Subject: [ADMIN] Whats the file extention for custom format in pg_dump can someone tell me the default file compression type for dumps taken using /usr/local/pgsql/bin/pg_dump -b -F c -h -d please any help would be great -- Best, Gourish Singbal ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org