Re: pg_upgrade + Extensions - Mailing list pgsql-hackers
From | Smitha Pamujula |
---|---|
Subject | Re: pg_upgrade + Extensions |
Date | |
Msg-id | CAGWGGXNNJ5J4kp2UWXedZ5+kkfZ95+vvtxY2A216geNhLxLQ=Q@mail.gmail.com Whole thread Raw |
In response to | Re: pg_upgrade + Extensions (Andrew Dunstan <andrew@dunslane.net>) |
Responses |
Re: pg_upgrade + Extensions
|
List | pgsql-hackers |
<div dir="ltr"><br /><div class="gmail_extra"><br /><div class="gmail_quote">On Mon, Jul 13, 2015 at 11:56 AM, Andrew Dunstan<span dir="ltr"><<a href="mailto:andrew@dunslane.net" target="_blank">andrew@dunslane.net</a>></span> wrote:<br/><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span class=""><br/> On 07/13/2015 01:12 PM, Smitha Pamujula wrote:<br /><blockquote class="gmail_quote" style="margin:0px 0px0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"> Yes. I havechecked that the extension didn't exist in any of the databases. I used \dx to see if there was json_build was listedand i didnt see any. Is that sufficient to check its existence. I am about to do another testing in a few minutes ona different machine. I will capture before/after shots<br /><br /><br /></blockquote><br /></span> Please don't top-poston the PostgreSQL lists - see <<a href="http://idallen.com/topposting.html" rel="noreferrer" target="_blank">http://idallen.com/topposting.html</a>><br/><br /> In theory it should be enough if it was installed inthe standard way. But a more thorough procedure would be to run this command:<br /><br /> select count(*)<br /> frompg_proc<br /> where prosrc ~ 'json_build';<br /><br /> Here's a one-liner that will check every database for you:<br/><br /> for db in `psql -t -c 'select datname from pg_database where<br /> datallowconn'` ; do C=`psql -t-c "select count(*) from pg_proc<br /> where prosrc ~ 'json_build'" $db`; echo $db $C; done<br /><br /> cheers<spanclass=""><font color="#888888"><br /><br /> andrew<br /></font></span></blockquote></div><br /><br /><font color="#0000ff">Ki have tested it on our db. Sorry for the long mail, most of it is just output from the commands. My commentsare in blue.</font></div><div class="gmail_extra"><font color="#0000ff"><br /></font></div><div class="gmail_extra"><fontcolor="#0000ff">Pre-upgrade:<br /></font><br /></div><div class="gmail_extra"><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial">psql<span style="color:rgb(128,128,48)">-</span>l List of databases Name <span style="color:rgb(128,128,48)">|</span> Owner <span style="color:rgb(128,128,48)">|</span> Encoding <span style="color:rgb(128,128,48)">|</span> Collate <span style="color:rgb(128,128,48)">|</span> Ctype <span style="color:rgb(128,128,48)">|</span> Access privileges <span style="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">+</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span>postgres <span style="color:rgb(128,128,48)">|</span>postgres <span style="color:rgb(128,128,48)">|</span> UTF8 <span style="color:rgb(128,128,48)">|</span>en_US<span style="color:rgb(128,128,48)">.</span>UTF<span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(0,140,0)">8</span> <span style="color:rgb(128,128,48)">|</span>en_US<span style="color:rgb(128,128,48)">.</span>UTF<span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(0,140,0)">8</span> <span style="color:rgb(128,128,48)">|</span>reporting<span style="color:rgb(128,128,48)">|</span> sqitch <span style="color:rgb(128,128,48)">|</span>UTF8 <span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">=</span>Tc<spanstyle="color:rgb(128,128,48)">/</span>sqitch <span style="color:rgb(128,128,48)">+</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> sqitch<span style="color:rgb(128,128,48)">=</span>CTc<spanstyle="color:rgb(128,128,48)">/</span>sqitch <span style="color:rgb(128,128,48)">+</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> owner_gulper<span style="color:rgb(128,128,48)">=</span>C<spanstyle="color:rgb(128,128,48)">/</span>sqitch <span style="color:rgb(128,128,48)">+</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> owner_reporting<span style="color:rgb(128,128,48)">=</span>C<spanstyle="color:rgb(128,128,48)">/</span>sqitchtemplate0 <span style="color:rgb(128,128,48)">|</span>postgres <span style="color:rgb(128,128,48)">|</span> UTF8 <span style="color:rgb(128,128,48)">|</span>en_US<span style="color:rgb(128,128,48)">.</span>UTF<span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(0,140,0)">8</span> <span style="color:rgb(128,128,48)">|</span>en_US<span style="color:rgb(128,128,48)">.</span>UTF<span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(0,140,0)">8</span> <span style="color:rgb(128,128,48)">|</span><span style="color:rgb(128,128,48)">=</span>c<span style="color:rgb(128,128,48)">/</span>postgres <span style="color:rgb(128,128,48)">+</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span>postgres<span style="color:rgb(128,128,48)">=</span>CTc<span style="color:rgb(128,128,48)">/</span>postgrestemplate1<span style="color:rgb(128,128,48)">|</span> postgres <span style="color:rgb(128,128,48)">|</span>UTF8 <span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">=</span>c<spanstyle="color:rgb(128,128,48)">/</span>postgres <span style="color:rgb(128,128,48)">+</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> postgres<span style="color:rgb(128,128,48)">=</span>CTc<spanstyle="color:rgb(128,128,48)">/</span>postgres</pre><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial"><br/></pre><pre style="background-image:initial;background-repeat:initial"><fontcolor="#0000ff" face="arial, helvetica, sans-serif">Removedthe json_build extension from 9.3 database. Verified here:</font><font color="#000000"> </font></pre><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial"><pre style="background-image:initial;background-repeat:initial">fordb in `psql <span style="color:rgb(128,128,48)">-</span>t<span style="color:rgb(128,128,48)">-</span>c 'select datname from pg_database where <span style="color:rgb(128,128,48)">></span> datallowconn'` <span style="color:rgb(128,128,48)">;</span> do C<spanstyle="color:rgb(128,128,48)">=</span>`psql <span style="color:rgb(128,128,48)">-</span>t <span style="color:rgb(128,128,48)">-</span>c"select count<span style="color:rgb(105,105,105)">(*) from pg_proc</span> <span style="color:rgb(105,105,105)">> where prosrc ~ 'json_build'" $db`; echo $db $C; done</span> <span style="color:rgb(105,105,105)">template1 0</span> <span style="color:rgb(105,105,105)">postgres 0</span> <span style="color:rgb(105,105,105)">reporting 0</span></pre></pre><pre style="background-image:initial;background-repeat:initial"><fontcolor="#0000ff" face="arial, helvetica, sans-serif">ThenI installed the pg 9.4 and started the empty instance.</font></pre><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial"><pre style="background-image:initial;background-repeat:initial">psql<span style="color:rgb(128,128,48)">-</span>d postgres psql <span style="color:rgb(128,128,48)">(</span><span style="color:rgb(0,128,0)">9.3</span><span style="color:rgb(128,128,48)">.</span><spanstyle="color:rgb(0,140,0)">5</span><span style="color:rgb(128,128,48)">,</span>server <span style="color:rgb(0,128,0)">9.4</span><span style="color:rgb(128,128,48)">.</span><spanstyle="color:rgb(0,140,0)">4</span><span style="color:rgb(128,128,48)">)</span> <span style="color:rgb(227,74,220)">WARNING:</span> psql major version <span style="color:rgb(0,128,0)">9.3</span><span style="color:rgb(128,128,48)">,</span>server major version <span style="color:rgb(0,128,0)">9.4</span><span style="color:rgb(128,128,48)">.</span> Some psql features might not work<span style="color:rgb(128,128,48)">.</span> Type <span style="color:rgb(128,0,0)">"</span><span style="color:rgb(0,0,230)">help</span><span style="color:rgb(128,0,0)">"</span><span style="color:rgb(128,0,0);font-weight:bold">for</span> help<span style="color:rgb(128,128,48)">.</span> postgres<span style="color:rgb(128,128,48)">=</span><span style="color:rgb(128,128,48)">#</span> \l List of databases Name <span style="color:rgb(128,128,48)">|</span> Owner <span style="color:rgb(128,128,48)">|</span>Encoding <span style="color:rgb(128,128,48)">|</span> Collate <span style="color:rgb(128,128,48)">|</span> Ctype <span style="color:rgb(128,128,48)">|</span> Access privileges <span style="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">+</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">+</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(128,128,48)">-</span>postgres <span style="color:rgb(128,128,48)">|</span> postgres <span style="color:rgb(128,128,48)">|</span>UTF8 <span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span>template0 <span style="color:rgb(128,128,48)">|</span>postgres <span style="color:rgb(128,128,48)">|</span> UTF8 <span style="color:rgb(128,128,48)">|</span>en_US<span style="color:rgb(128,128,48)">.</span>UTF<span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(0,140,0)">8</span> <span style="color:rgb(128,128,48)">|</span>en_US<span style="color:rgb(128,128,48)">.</span>UTF<span style="color:rgb(128,128,48)">-</span><spanstyle="color:rgb(0,140,0)">8</span> <span style="color:rgb(128,128,48)">|</span><span style="color:rgb(128,128,48)">=</span>c<span style="color:rgb(128,128,48)">/</span>postgres <span style="color:rgb(128,128,48)">+</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span>postgres<span style="color:rgb(128,128,48)">=</span>CTc<span style="color:rgb(128,128,48)">/</span>postgrestemplate1<span style="color:rgb(128,128,48)">|</span> postgres <span style="color:rgb(128,128,48)">|</span>UTF8 <span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span> en_US<span style="color:rgb(128,128,48)">.</span>UTF<spanstyle="color:rgb(128,128,48)">-</span><span style="color:rgb(0,140,0)">8</span><span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">=</span>c<spanstyle="color:rgb(128,128,48)">/</span>postgres <span style="color:rgb(128,128,48)">+</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> <span style="color:rgb(128,128,48)">|</span> postgres<span style="color:rgb(128,128,48)">=</span>CTc<spanstyle="color:rgb(128,128,48)">/</span>postgres</pre></pre><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial"><br/></pre><pre style="background-image:initial;background-repeat:initial"><fontcolor="#0000ff" face="arial, helvetica, sans-serif">Now Iran the same extension check on the 94.</font></pre><pre style="background-image:initial;background-repeat:initial"><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial">fordb in `psql <span style="color:rgb(128,128,48)">-</span>t<span style="color:rgb(128,128,48)">-</span>c 'select datname from pg_database where <span style="color:rgb(128,128,48)">></span> datallowconn'` <span style="color:rgb(128,128,48)">;</span> do C<spanstyle="color:rgb(128,128,48)">=</span>`psql <span style="color:rgb(128,128,48)">-</span>t <span style="color:rgb(128,128,48)">-</span>c"select count<span style="color:rgb(105,105,105)">(*) from pg_proc</span> <span style="color:rgb(105,105,105)">> where prosrc ~ 'json_build'" $db`; echo $db $C; done</span> <span style="color:rgb(105,105,105)">template1 4</span> <span style="color:rgb(105,105,105)">postgres 4</span></pre><pre style="background-image:initial;background-repeat:initial"><fontcolor="#0000ff" face="arial, helvetica, sans-serif">I seethat its got the new procs as part of the 94. Now if i do the check link its giving me this error.</font></pre><pre style="background-image:initial;background-repeat:initial"><fontcolor="#000000">[postgres@pdxqarptsrd04 pg_94_upgrade]$ /usr/pgsql-9.4/bin/pg_upgrade--check --link Performing Consistency Checks ----------------------------- Checking cluster versions ok Checking database user is a superuser ok Checking database connection settings ok Checking for prepared transactions ok Checking for reg* system OID user data types ok Checking for contrib/isn with bigint-passing mismatch ok Checking for invalid "line" user columns ok Checking for presence of required libraries fatal Your installation references loadable libraries that are missing from the new installation. You can add these libraries to the new installation, or remove the functions using them from the old installation. A list of problem libraries is in the file: loadable_libraries.txt Failure, exiting [postgres@pdxqarptsrd04 pg_94_upgrade]$ cat loadable_libraries.txt Could not load library "$libdir/json_build" ERROR: could not access file "$libdir/json_build": No such file or directory</font></pre><pre style="background-image:initial;background-repeat:initial"><br/></pre><pre style="background-image:initial;background-repeat:initial">[postgres@pdxqarptsrd04pg_94_upgrade]$ rpm -qa|grep json_build json_build93-1.0.0-1iov.x86_64<br /></pre><pre style="background-image:initial;background-repeat:initial"><font color="#0000ff"face="arial, helvetica, sans-serif">This error will go away only if I install the new json_build94.</font></pre><prestyle="background-image:initial;background-repeat:initial"><pre style="color:rgb(0,0,0);background-image:initial;background-repeat:initial"><span style="color:rgb(166,87,0)">[</span><spanstyle="color:rgb(95,80,53)">postgres@pdxqarptsrd04 pg_94_upgrade</span><span style="color:rgb(166,87,0)">]</span>$rpm <span style="color:rgb(121,121,151)">-</span><span style="color:rgb(0,121,151)">qa|grep</span>json_build json_build94<span style="color:rgb(128,128,48)">-</span><span style="color:rgb(0,128,0)">1.0</span><span style="color:rgb(128,128,48)">.</span><spanstyle="color:rgb(0,140,0)">0</span><span style="color:rgb(128,128,48)">-</span>1iov<spanstyle="color:rgb(128,128,48)">.</span>x86_64 json_build93<span style="color:rgb(128,128,48)">-</span><span style="color:rgb(0,128,0)">1.0</span><span style="color:rgb(128,128,48)">.</span><spanstyle="color:rgb(0,140,0)">0</span><span style="color:rgb(128,128,48)">-</span>1iov<spanstyle="color:rgb(128,128,48)">.</span>x86_64</pre><pre style="background-image:initial;background-repeat:initial"><fontcolor="#000000">[postgres@pdxqarptsrd04 pg_94_upgrade]$ /usr/pgsql-9.4/bin/pg_upgrade--check --link Performing Consistency Checks ----------------------------- Checking cluster versions ok Checking database user is a superuser ok Checking database connection settings ok Checking for prepared transactions ok Checking for reg* system OID user data types ok Checking for contrib/isn with bigint-passing mismatch ok Checking for invalid "line" user columns ok Checking for presence of required libraries ok Checking database user is a superuser ok Checking for prepared transactions ok *Clusters are compatible*<br /></font></pre><pre style="background-image:initial;background-repeat:initial"><br /></pre><prestyle="background-image:initial;background-repeat:initial"><font color="#0000ff" face="arial, helvetica, sans-serif">Iwas under the impression that we dont need to get the json_build libraries for 94. But the upgrade wont go forwardwithout that. Are we missing doing something here or is it necessarty to get json_build94 before upgrade.</font></pre><prestyle="background-image:initial;background-repeat:initial"><font color="#0000ff" face="arial, helvetica,sans-serif"><br /></font></pre><pre style="background-image:initial;background-repeat:initial"><font color="#0000ff"face="arial, helvetica, sans-serif">Thanks</font></pre><pre style="background-image:initial;background-repeat:initial"><fontcolor="#0000ff" face="arial, helvetica, sans-serif">Smitha</font></pre></pre></pre></div><divclass="gmail_extra"></div></div>
pgsql-hackers by date: