Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.
От | |
---|---|
Тема | Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space. |
Дата | |
Msg-id | 20130307070349.5a830134ae84016b0174832fdc1a3173.6d6146fe94.wbe@email11.secureserver.net обсуждение исходный текст |
Ответы |
Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.
(Kevin Grittner <kgrittn@ymail.com>)
|
Список | pgsql-bugs |
<span style=3D"font-family:Verdana; color:#000000; font-size:10= pt;"><span style= =3D"">Does anyone know, what the names/location of the pg_upgrade cleanup s= cripts? We upgraded from 8.4.3 to 9.1.6<font face= =3D"verdana, geneva" size=3D"2" style=3D""></fo= nt><span st= yle=3D"">thanks<font face=3D"verdana, geneva" size= =3D"2" style=3D""><blockquote id= =3D"replyBlockquote" webmail=3D"1" style=3D"color: black; font-family: verd= ana; font-size: 10pt; border-left-width: 2px; border-left-style: solid; bor= der-left-color: blue; margin-left: 8px; padding-left: 8px; "><div id=3D"wmQ= uoteWrapper"><span style=3D"font-family:Verdana; color:#000000; font-size:1= 0pt;"> <blockquote style=3D"BORDER-LEFT: blue 2px solid; = PADDING-LEFT: 8px; FONT-FAMILY: verdana; COLOR: black; MARGIN-LEFT: 8px; FO= NT-SIZE: 10pt" id=3D"replyBlockquote" webmail=3D"1"> <div id=3D"wmQuoteWrap= per">= <blockquote style=3D"BORDER-LEFT: blue 2px solid; PADDING-LEFT: 8px; FONT-= FAMILY: verdana; COLOR: black; MARGIN-LEFT: 8px; FONT-SIZE: 10pt" id=3D"rep= lyBlockquote" webmail=3D"1"> -------- Original M= essage --------Subject: Re: [BUGS] Excessive space allocations in Postg= resql 9.1.6system files causing the file system to run out of space.<br= >From: Kevin Grittner <<a href=3D"mailto:kgrittn@ymail.com" target=3D"_b= lank">kgrittn@ymail.com>Date: Fri, March 01, 2013 9:00 amTo:= "fburgess@ra= diantblue.com" <<a href=3D"mailto:fburgess@radiantblue.com" target= =3D"_blank">fburgess@radiantblue.com>, AndresFreund <<a href= =3D"mailto:andres@2ndquadrant.com" target=3D"_blank">andres@2ndquadrant.com= >Cc: "<a href=3D"mailto:pgsql-bugs@postgresql.org" target=3D"_bl= ank">pgsql-bugs@postgresql.org" <<a href=3D"mailto:pgsql-bugs@postgr= esql.org" target=3D"_blank">pgsql-bugs@postgresql.org>"<a hr= ef=3D"mailto:fburgess@radiantblue.com" target=3D"_blank">fburgess@radiantbl= ue.com" <<a href=3D"mailto:fburgess@radiantblue.com" target=3D"_blan= k">fburgess@radiantblue.com> wrote:> We did use pg_upgrad= e with the hard link option. We are not sure> if we ran the cleanup = script.> Can we run this script now, even though its month's aft= er we did> the upgrade?> Everything in the .../19177 dire= ctories represent data files> migrated over form postgres 8.4.3.&nbs= p; All new files get placed into> the .../PG_9.1_201105231/16411 dir= ectories.> The vast majority of the "orphan" files are from the<= br>> /opt/PostgreSQL/9.1/data/user_data/19177 directory.I = don't have any reason to expect that you *can't* run the scriptat this = point; but being a cautious person, I would do this at apoint where I w= as confident I could recover from a backup, and Iwould read through the= scripts carefully before applying them.What you want to be really = careful that you *don't* do is to modifyor truncate any of the hard-lin= ked files, as they are quite likelyto still be just another name for th= e same file that is in use forproduction under the newer version. = You want to simply remove theolder directory entry pointing to the fil= e.<a href=3D"http://www.linfo.org/hard_link.html" target=3D"_blank"= >http://www.linfo.org/hard_link.html-- Kevin GrittnerEn= terpriseDB: http= ://www.enterprisedb.comThe Enterprise PostgreSQL Company<br= >-- Sent via pgsql-bugs mailing list (<a href=3D"mailto:pgsql-bugs@post= gresql.org" target=3D"_blank">pgsql-bugs@postgresql.org)To make cha= nges to your subscription:<a href=3D"http://www.postgresql.org/mailpref= /pgsql-bugs" target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-bug= s =0A=0A<= /blockquote>
В списке pgsql-bugs по дате отправления:
Предыдущее
От: keith@omniti.comДата:
Сообщение: BUG #7923: PGP secret key with password decryption not working
Следующее
От: Kevin GrittnerДата:
Сообщение: Re: Excessive space allocations in Postgresql 9.1.6 system files causing the file system to run out of space.