<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><DIV>Thanks Kevin & Bruce for your replies,</DIV>
<DIV> </DIV>
<DIV>It looks like this script deletes all of the data file directories (and the data files) from the postgres 8.4.3 instance. Since we used the "-k" option, which calls for hard links rather than copying files to the new cluster, wouldn't this be deleting the files? If so, the DB would be corrupted beyond recovery if we run it. Or am I missing something?</DIV>
<DIV> </DIV>
<DIV>thanks</DIV>
<DIV> </DIV>
<DIV>Freddie</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: Thu, March 07, 2013 8:14 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>>, <BR>"<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>> Does anyone know, what the names/location of the pg_upgrade<BR>> cleanup scripts? We upgraded from 8.4.3 to 9.1.6<BR><BR>Sorry I didn't answer this sooner, but I didn't know off-hand and<BR>hoped that someone who did would jump in. Since that didn't happen<BR>...<BR><BR>The file is <a href="http://delete_old_cluster.sh">delete_old_cluster.sh</a> on most platforms. The suffix is<BR>.bat on Windows.<BR><BR>It can be run anytime after the upgrade *as long as you have not<BR>moved the new cluster to the old location*.<BR><BR>Thanks to Bruce Momjian for telling me in chat when I asked just now.<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>