Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A6C37650068 for ; Wed, 6 Aug 2008 09:36:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89738-01 for ; Wed, 6 Aug 2008 09:36:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.153]) by postgresql.org (Postfix) with ESMTP id 7175B64FF2F for ; Wed, 6 Aug 2008 09:36:11 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so2295156fgg.23 for ; Wed, 06 Aug 2008 05:36:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=c2kX0GfNSkfkuDF9Jv3I/H2vP8pT3StsQAhdh8C1B6c=; b=ABb2GtPz1HFlga3l7YOgEzMIu7cklaZVpKvioNKPAtpqeBZj8w2U2xU/cdDFYiNUS5 sVYwQ3Sy9iSubQJYiDqq2XXpaeR5UefsZjfPLF45PJ546bci3Fy9zZoVZthfvXoYUGYp mgFodKOhFgHjwbfy4g/M9mFiOzKcSqL4KWTkg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=q67zVvc/7nLsmWL+Oo2pyqH81Pun788VUBKWU4pLK2CEGFPeXJBo9WG7iXgNpjtpcj 9cqND34byZSkNc2/8RPajnuzNyIYMM2JuIOWTG/Pwfc0gkrJA2bz/vRc4AJsOKH0bIb4 kvbgDcuGBzccsp5rZEbxpxFNKzAvvsu0Azq8g= Received: by 10.86.66.11 with SMTP id o11mr749019fga.69.1218026169547; Wed, 06 Aug 2008 05:36:09 -0700 (PDT) Received: by 10.86.73.10 with HTTP; Wed, 6 Aug 2008 05:36:09 -0700 (PDT) Message-ID: Date: Wed, 6 Aug 2008 18:06:09 +0530 From: "Amit jain" To: pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org, tgl@sss.pgh.pa.us Subject: pg_restore -d cipa /cipa/RAJASTHAN/RAJASTHAN/CIPABACKUP01_08_2008.TAR pg_restore: [archiver] out of memory MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_66929_2580579.1218026169542" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200808/21 X-Sequence-Number: 29866 ------=_Part_66929_2580579.1218026169542 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Dear All, I am having a backup file in tar format. While restoring it through pg_restore instantly i am getting an following error. *Command - pg_restore -d cipa /cipa/RAJASTHAN/RAJASTHAN/CIPABACKUP01_08_2008.TAR Error - pg_restore: [archiver] out of memory *I have increased shmmax , maintenace work memory but still i am getting the same error. 2. I have make all log_parameter to debug5 but still getting a single error -line while restoring not getting any log or debug info about it. Kindly help me out from this absurd behaviour of postgreSQL restoration process. Any help would be highly appreciated. Thanx in advance Thanks n Regards Amit jain 9818450022 ------=_Part_66929_2580579.1218026169542 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Dear All,

 I am having a backup file in tar format. While restoring it through pg_restore instantly i am getting an following error.
Command - pg_restore -d cipa /cipa/RAJASTHAN/RAJASTHAN/CIPABACKUP01_08_2008.TAR
Error  - pg_restore: [archiver] out of memory
I have increased shmmax , maintenace work memory but still i am getting the same error.

2. I have make all log_parameter to debug5 but still getting a single error -line while restoring not getting any log or debug info about it.

Kindly help me out from this absurd behaviour of postgreSQL restoration process.
Any help would be highly appreciated. Thanx in advance

Thanks n Regards
Amit jain
9818450022

------=_Part_66929_2580579.1218026169542--