Thread: Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.
<span style=3D"font-family:Verdana; color:#000000; font-size:10= pt;">Thanks Kevin & Bruce for your replies,=0A </D= IV>=0AIt looks like this script deletes all of the data file dire= ctories (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 fil= es to the new cluster, wouldn't this be deleting the files? If s= o, the DB would be corrupted beyond recovery if we run it. Or am I&nb= sp;missing something?=0A =0Athanks=0A= =0AFreddie=0A =0A<BLOCKQUOTE style= =3D"BORDER-LEFT: blue 2px solid; PADDING-LEFT: 8px; FONT-FAMILY: verdana; C= OLOR: black; MARGIN-LEFT: 8px; FONT-SIZE: 10pt" id=3DreplyBlockquote webmai= l=3D"1">=0A-------- Original Message --------S= ubject: Re: [BUGS] Excessive space allocations in Postgresql 9.1.6syste= m files causing the file system to run out of space.From: Kevin Grittne= r <kgrittn@ymail.com>Dat= e: Thu, March 07, 2013 8:14 amTo: "<a href=3D"mailto:fburgess@radiantbl= ue.com">fburgess@radiantblue.com" <<a href=3D"mailto:fburgess@radian= tblue.com">fburgess@radiantblue.com>, "<a href=3D"mailto:pgsql-b= ugs@postgresql.org">pgsql-bugs@postgresql.org" <<a href=3D"mailto:pg= sql-bugs@postgresql.org">pgsql-bugs@postgresql.org>"<a href= =3D"mailto:fburgess@radiantblue.com">fburgess@radiantblue.com" <<a h= ref=3D"mailto:fburgess@radiantblue.com">fburgess@radiantblue.com> wr= ote:> Does anyone know, what the names/location of the pg_upgrad= e> cleanup scripts? We upgraded from 8.4.3 to 9.1.6Sorry I d= idn't answer this sooner, but I didn't know off-hand andhoped that some= one who did would jump in. Since that didn't happen...The= file is delete_old_cluster.sh= on most platforms. The suffix is.bat on Windows.It can b= e run anytime after the upgrade *as long as you have notmoved the new c= luster to the old location*.Thanks to Bruce Momjian for telling me = in chat when I asked just now.--Kevin GrittnerEnterpriseDB:= http://www.enterprisedb.com<BR= >The Enterprise PostgreSQL Company-- Sent via pgsql-bugs ma= iling list (pgsql-bugs@postgre= sql.org)To make changes to your subscription:<a href=3D"http://= www.postgresql.org/mailpref/pgsql-bugs">http://www.postgresql.org/mailpref/= pgsql-bugs
Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.
From
Kevin Grittner
Date:
"fburgess@radiantblue.com" <fburgess@radiantblue.com> wrote:=0A=0A> It look= s like this script deletes all of the data file=0A> directories (and the da= ta files) from the postgres 8.4.3=0A> instance. Since we used the "-k" opti= on, which calls for hard=0A> links rather than copying files to the new clu= ster, wouldn't this=0A> be deleting the files?=A0 If so, the DB would be co= rrupted beyond=0A> recovery if we run it.=A0 Or am I missing something?=0A= =0AYou need to read up on hard links a bit more.=A0 Here's one source:=0A= =0Ahttp://www.linfo.org/hard_link.html=0A=0AIn summary, a hard link allows = multiple directory entries to point=0Ato the same data location.=A0 Until y= ou delete the last directory=0Aentry the file remains.=0A=0A-- =0AKevin Gri= ttner=0AEnterpriseDB: http://www.enterprisedb.com=0AThe Enterprise PostgreS= QL Company