<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Hi Kevin,</div>
<div> </div>
<div>Do you know the name that was given to the cleanup script?</div>
<div> </div>
<div>thanks</div>
<div> </div>
<BLOCKQUOTE style="BORDER-LEFT: blue 2px solid; PADDING-LEFT: 8px; FONT-FAMILY: verdana; COLOR: black; MARGIN-LEFT: 8px; FONT-SIZE: 10pt" id=replyBlockquote webmail="1">
<DIV id=wmQuoteWrapper>-------- Original Message --------<BR>Subject: Re: [BUGS] Excessive space allocations in Postgresql 9.1.6<BR>system files causing the file system to run out of space.<BR>From: Kevin Grittner <<a href="mailto:kgrittn(at)ymail(dot)com">kgrittn(at)ymail(dot)com</a>><BR>Date: Fri, March 01, 2013 9:00 am<BR>To: "<a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a>" <<a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a>>, Andres<BR>Freund <<a href="mailto:andres(at)2ndquadrant(dot)com">andres(at)2ndquadrant(dot)com</a>><BR>Cc: "<a href="mailto:pgsql-bugs(at)postgresql(dot)org">pgsql-bugs(at)postgresql(dot)org</a>" <<a href="mailto:pgsql-bugs(at)postgresql(dot)org">pgsql-bugs(at)postgresql(dot)org</a>><BR><BR>"<a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a>" <<a href="mailto:fburgess(at)radiantblue(dot)com">fburgess(at)radiantblue(dot)com</a>> wrote:<BR><BR>> We did use pg_upgrade with the hard link option. We are not sure<BR>> if we ran the cleanup script.<BR><BR>> Can we run this script now, even though its month's after we did<BR>> the upgrade?<BR><BR>> Everything in the .../19177 directories represent data files<BR>> migrated over form postgres 8.4.3. All new files get placed into<BR>> the .../PG_9.1_201105231/16411 directories.<BR><BR>> The vast majority of the "orphan" files are from the<BR>> /opt/PostgreSQL/9.1/data/user_data/19177 directory.<BR><BR>I don't have any reason to expect that you *can't* run the script<BR>at this point; but being a cautious person, I would do this at a<BR>point where I was confident I could recover from a backup, and I<BR>would read through the scripts carefully before applying them.<BR><BR>What you want to be really careful that you *don't* do is to modify<BR>or truncate any of the hard-linked files, as they are quite likely<BR>to still be just another name for the same file that is in use for<BR>production under the newer version. You want to simply remove the<BR>older directory entry pointing to the file.<BR><BR><a href="http://www.linfo.org/hard_link.html">http://www.linfo.org/hard_link.html</a><BR><BR>-- <BR>Kevin Grittner<BR>EnterpriseDB: <a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><BR>The Enterprise PostgreSQL Company<BR><BR><BR>-- <BR>Sent via pgsql-bugs mailing list (<a href="mailto:pgsql-bugs(at)postgresql(dot)org">pgsql-bugs(at)postgresql(dot)org</a>)<BR>To make changes to your subscription:<BR><a href="http://www.postgresql.org/mailpref/pgsql-bugs">http://www.postgresql.org/mailpref/pgsql-bugs</a><BR></DIV></BLOCKQUOTE></span></body></html>