Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id E68D82E0065 for ; Wed, 11 Jun 2008 13:11:28 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45929-04 for ; Wed, 11 Jun 2008 13:11:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from polaris.pinpointresearch.com (66-7-238-130.static-ip.telepacific.net [66.7.238.130]) by developer.postgresql.org (Postfix) with ESMTP id 6C92A2E002E for ; Wed, 11 Jun 2008 13:11:23 -0300 (ADT) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id A6461E00EC80; Wed, 11 Jun 2008 09:11:21 -0700 (PDT) Message-ID: <484FF929.8050505@pinpointresearch.com> Date: Wed, 11 Jun 2008 09:11:21 -0700 From: Steve Crawford User-Agent: Thunderbird 2.0.0.14 (X11/20080502) MIME-Version: 1.0 To: "Joshua D. Drake" CC: Devendra Singh Rawat , "pgsql-admin@postgresql.org" Subject: Re: Disk Space issue References: <484E61A0.5030706@kerkhove.net> <484E88AB.6020505@kerkhove.net> <4242E42288B6E842A52B88D4B3A3E620E0610550@AUSMELMBX01.ad.infosys.com> <1213142115.17340.213.camel@jd-laptop> In-Reply-To: <1213142115.17340.213.camel@jd-laptop> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/99 X-Sequence-Number: 29437 Joshua D. Drake wrote: > On Wed, 2008-06-11 at 09:36 +1000, Devendra Singh Rawat wrote: > >> Hi, >> >> We are using PostgreSQL 7.4.5 and facing issues with increasing disk space.... >> >> > ...I would also suggest strongly you update to the latest 7.4 dot release. > But as always read all the release notes between your current and your intended version. Usually all that is required for maintenance upgrades is installing new binaries but you can't assume that is always the case. For the 7.4 series, pay special attention to the notes for 7.4.8 and 7.4.11: http://www.postgresql.org/docs/7.4/static/release-7-4-8.html http://www.postgresql.org/docs/7.4/static/release-7-4-11.html Since it sounds like you are doing lots of dump and restore, these issues may not be problematic for you. If possible in your situation, updating to the latest version (8.3.1) is preferable. Cheers, Steve