X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EA39CD1B49F for ; Tue, 13 Apr 2004 13:33:22 -0300 (ADT) 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 83214-03 for ; Tue, 13 Apr 2004 13:33:20 -0300 (ADT) Received: from COLSWEEPER.cranel.local (newmail.cranel.com [66.192.200.227]) by svr1.postgresql.org (Postfix) with ESMTP id 5FCF3D1BAFC for ; Tue, 13 Apr 2004 13:33:19 -0300 (ADT) Received: from colmail01.cranel.local (colmail01.cranel.com) by COLSWEEPER.cranel.local (Content Technologies SMTPRS 4.3.12) with ESMTP id ; Tue, 13 Apr 2004 12:32:45 -0400 Received: from cranel.com (192.168.11.134 [192.168.11.134]) by colmail01.cranel.local with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 2ZCRR61A; Tue, 13 Apr 2004 12:37:36 -0400 Message-ID: <407C1641.2070800@cranel.com> Date: Tue, 13 Apr 2004 12:33:05 -0400 From: Greg Spiegelberg Organization: Cranel, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: JinNet Picker Cc: pgsql-admin@postgresql.org Subject: Re: Postgres Admin - Export Database References: <20040413083659.50610.qmail@web9406.mail.yahoo.com> In-Reply-To: <20040413083659.50610.qmail@web9406.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/202 X-Sequence-Number: 13175 JinNet Picker wrote: > Hi, > > I am trying to take Database backup. I use this > command. > > # ./pg_dump -U username -cif filename.sql dbname > > Its exporting, but in the Log, its giving like > > "LOG: out of file descriptors: Too many open files; > release and retry" > > Can anybody tell me what is this? And what i have to > do clear this out?? Try the pg_dump option "-F t". It will create a single tar file that pg_restore can use. ./pg_dump -U username -ci -F t -f filename.tar dbname Greg -- Greg Spiegelberg Product Development Manager Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: gspiegelberg@cranel.com Technology. Integrity. Focus. V-Solve!