Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45863=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bn1X9-0003Df-NL
	for pgsql-admin@arkaria.postgresql.org; Thu, 22 Sep 2016 10:47:16 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45863=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bn1X8-0008GY-Ix
	for pgsql-admin@arkaria.postgresql.org; Thu, 22 Sep 2016 10:47:14 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <uko@avast.com>)
	id 1bn1X8-0008GS-1F
	for pgsql-admin@postgresql.org; Thu, 22 Sep 2016 10:47:14 +0000
Received: from mail-vk0-x22a.google.com ([2607:f8b0:400c:c05::22a])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <uko@avast.com>)
	id 1bn1Wy-0001pb-LU
	for pgsql-admin@postgresql.org; Thu, 22 Sep 2016 10:47:13 +0000
Received: by mail-vk0-x22a.google.com with SMTP id 192so18785533vkl.0
        for <pgsql-admin@postgresql.org>;
 Thu, 22 Sep 2016 03:47:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=avast-com.20150623.gappssmtp.com; s=20150623;
        h=from:references:in-reply-to:mime-version:thread-index:date
         :message-id:subject:to;
        bh=vsV32cfbwAxm2Y9S6l4705p1pFNgiZCVdwr0I/DvHew=;
        b=rMlpmNNfTaoN0mCuZ/arfkSRXXSzGdvtyLdng3Xe9EHkXRObdG5YeObnt7G0nWK3Er
         6ROyuiIB8V2FsGpo/p/6NodebKuyqk+J4FdfQeIgNXQfWI5TWkp81QcNCo4HIS2x+uYx
         mZRFYWkkNsHJRgtvTJ9PkGJHM/CwZ/E2+cMP5+sVWNuxe7h5+Ms4jNSmVFm3uCuyNsLP
         N0WebVqdmgS7l7YjYVV3101IR3ibIuJI3vDYI0bg9oo2ADc55zwgsoApylwXSY+/yHfd
         QzmUqMDIBRlheG8G45+S2PQm75C8au6HhWmQPblmiBJ/4e+DyUMdlUIj8fNIttA6fJOW
         9KFg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:from:references:in-reply-to:mime-version
         :thread-index:date:message-id:subject:to;
        bh=vsV32cfbwAxm2Y9S6l4705p1pFNgiZCVdwr0I/DvHew=;
        b=hqXPbwJh8CzfaUz+3RLYTYzvUT0e4M/gkfGsM0ij8UCOW3YsHq1kBjZrqQzi1hXNYi
         Thm1wy+2toiBV6XM6SLGxfIYtBkHG9BAk9Lo02m0/mTkuFUAiICIdz3rMb++exDl0YHn
         q0BBx4UIYNbvL2iIte7GxcXrcOs2zUtCwiZTAyRTZCbKP/WmEQP3Ae/6eYk3tgYkXfqv
         pawuqSIWc3j1p1Mhh1EPQ025CuC8Hjvc9lMTa2aNC73ITFkKdqI53/nlqNO7Fm3Pf+Q5
         PxkhFmp/D1qV5/mrLE0Suex+yCXhUa4+Au2I1d3qzjCZ2lzgxPIr58D5yR+ECjyjDMye
         NENA==
X-Gm-Message-State: 
 AE9vXwOckypKn7EZegR5PVwVMtKpoZv9sFT66aBIt1n0uTT3dg4Bihec5kL/3c1F3CZJUt2606RNm7JZjFdb9O45
X-Received: by 10.31.235.3 with SMTP id j3mr811432vkh.33.1474541221815; Thu,
 22 Sep 2016 03:47:01 -0700 (PDT)
From: =?UTF-8?B?VG9tw6HFoSBVa28=?= <uko@avast.com>
References: 
 <CANYp5wr3cPWZ9QvW1CMn-LtK=7orR=JUdPUndivNM_QrC+0TNQ@mail.gmail.com>
 <CANUg7LBybkWvuMr8dM+bM6hExmQ8Lmv3++_+48_PCLy1qh06rA@mail.gmail.com>
 <05172a3859cb6805b368084dfd015dbc@mail.gmail.com>
In-Reply-To: <05172a3859cb6805b368084dfd015dbc@mail.gmail.com>
MIME-Version: 1.0
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AQJeZc6q4p7G23ZWufj/ZOJoeizsWAJCsalDAuAQpvKfQ5r+YA==
Date: Thu, 22 Sep 2016 12:46:59 +0200
Message-ID: <c02d9c97c1a7ba62c221625bf063907d@mail.gmail.com>
Subject: Re: Problem with extension
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=94eb2c092d2cbbbddc053d1661f8
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--94eb2c092d2cbbbddc053d1661f8
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Another thing,



Recreating extension again via =E2=80=9ECREATE EXTENSION=E2=80=9C doesn=E2=
=80=99t work

XY=3D# CREATE EXTENSION hstore SCHEMA public;

ERROR:  type "hstore" already exists

XY=3D# CREATE EXTENSION hstore;

ERROR:  type "hstore" already exists



Any ideas?







*From:* Tom=C3=A1=C5=A1 Uko [mailto:uko@avast.com]
*Sent:* Wednesday, September 21, 2016 4:58 PM
*To:* Payal Singh <payal@omniti.com>
*Cc:* pgsql-admin@postgresql.org
*Subject:* RE: [ADMIN] Problem with extension



Hi,



Sure, otherwise tables with hstore column won=E2=80=99t be created/usable (=
IMHO).
Extension is part of contrib package (if I remember correctly)



[root@XX ~]# ls -al
/usr/pgsql-9.3/lib/hstore.so


-rwxr-xr-x 1 root root 56336 May 11 16:59 /usr/pgsql-9.3/lib/hstore.so



[root@XX ~]# ls -al /usr/pgsql-9.3/share/extension/hstore*

-rw-r--r-- 1 root root   279 May 11 16:57
/usr/pgsql-9.3/share/extension/hstore--1.0--1.1.sql


-rw-r--r-- 1 root root  1201 May 11 16:57
/usr/pgsql-9.3/share/extension/hstore--1.1--1.2.sql


-rw-r--r-- 1 root root 12646 May 11 16:57
/usr/pgsql-9.3/share/extension/hstore--1.2.sql


-rw-r--r-- 1 root root   158 May 11 16:57
/usr/pgsql-9.3/share/extension/hstore.control


-rw-r--r-- 1 root root  5509 May 11 16:57
/usr/pgsql-9.3/share/extension/hstore--unpackaged--1.0.sql




T.



*From:* Payal Singh [mailto:payal@omniti.com]
*Sent:* Wednesday, September 21, 2016 4:34 PM
*To:* Uko, Tom=C3=A1=C5=A1 <uko@avast.com>
*Cc:* pgsql-admin@postgresql.org
*Subject:* Re: [ADMIN] Problem with extension



On the problematic machines, do you see a hstore.so file in the pgsql/lib
directory?



Also, do you see hstore sql files in the pgsql/share/extension directory?


Payal Singh,
Database Administrator,

OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253



On Wed, Sep 21, 2016 at 6:09 AM, Uko, Tom=C3=A1=C5=A1 <uko@avast.com> wrote=
:

Hi everybody, We have a problem with postgres extensions, we have several
servers with several instances on each of them (together 42). Each of those
instances are same (except table names - aplication partitioning). But when
we are preparing to migrate to newer version of Postgres, we discovered
this.

On all servers, there are tables with hstore columns, therefore there is
hstore extension in use. In order to upgrade from 9.3 to 9.5 we need to run
"ALTER EXTENSION hstore UPDATE;" on each database. But on some instances,
it says, there is no extension hstore:



XY=3D# alter extension hstore update;

ERROR:  extension "hstore" does not exist



On "correct" instance \dx shows (after alter):

XY=3D# \dx

                             List of installed extensions

    Name     | Version |   Schema   |                   Description

-------------+---------+------------+--------------------------------------=
------------

 adminpack   | 1.0     | pg_catalog | administrative functions for
PostgreSQL

 hll         | 1.0     | public     | type for storing hyperloglog data

 hstore      | 1.2     | public     | data type for storing sets of (key,
value) pairs

 pgstattuple | 1.0     | public     | show tuple-level statistics

 plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language

(5 rows)



On "weird" one \dx shows:

XY=3D# \dx

                         List of installed extensions

    Name     | Version |   Schema   |               Description

-------------+---------+------------+--------------------------------------=
---

 adminpack   | 1.0     | pg_catalog | administrative functions for
PostgreSQL

 hll         | 1.0     | public     | type for storing hyperloglog data

 pgstattuple | 1.0     | public     | show tuple-level statistics

 plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language

(4 rows)





We are running:

Name        : postgresql93-server

Arch        : x86_64

Version     : 9.3.13

Release     : 1PGDG.rhel6



On  CentOS 6 2.6.32-431.20.3.el6.x86_64

Each instance has a replica on different machine (via WAL shipping as well
as streaming replication) and problem is on both of them (master and slave)





Weird is, when we try to add extension again (via CREATE EXTENSION), it
ends up succesfully, but \dx won't show it



Another thing, when we try to add extesion with insert to pg_extension it
gets OID  far greater than any other:

XY=3D# select *,pg_extension.oid from pg_extension;

   extname   | extowner | extnamespace | extrelocatable | extversion |
extconfig | extcondition |    oid

-------------+----------+--------------+----------------+------------+-----=
------+--------------+-----------

 plpgsql     |       10 |           11 | f              | 1.0        |
      |              |     12617

 adminpack   |       10 |           11 | f              | 1.0        |
      |              |     16471

 hll         |       10 |         2200 | f              | 1.0        |
      |              |     16472

 pgstattuple |       10 |         2200 | t              | 1.0        |
      |              |     16473

 hstore      |       10 |         2200 | t              | 1.2        |
      |              | 366992783



 Any ideas what to do to fix?



 Thanks

 Tomas

--94eb2c092d2cbbbddc053d1661f8
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=
=3Dutf-8"><meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered m=
edium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:Helvetica;
	panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
	{mso-style-name:msonormal;
	mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;}
span.EmailStyle18
	{mso-style-type:personal;
	font-family:"Calibri",sans-serif;
	color:#1F497D;}
span.EmailStyle19
	{mso-style-type:personal;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
span.EmailStyle20
	{mso-style-type:personal-reply;
	font-family:"Calibri",sans-serif;
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--></style></head><body lang=3D"CS" link=3D"blue" vlink=3D"purple"><div cla=
ss=3D"WordSection1"><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497=
d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Calib=
ri&quot;,sans-serif;color:#1f497d">Another thing, </span></font></p><p clas=
s=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span s=
tyle=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#=
1f497d">=C2=A0</span></font></p><p class=3D"MsoNormal"><font size=3D"2" col=
or=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family=
:&quot;Calibri&quot;,sans-serif;color:#1f497d">Recreating extension again v=
ia =E2=80=9ECREATE EXTENSION=E2=80=9C doesn=E2=80=99t work</span></font></p=
><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"=
><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif=
;color:#1f497d">XY=3D# CREATE EXTENSION hstore SCHEMA public;</span></font>=
</p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calib=
ri"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-se=
rif;color:#1f497d">ERROR:=C2=A0 type &quot;hstore&quot; already exists</spa=
n></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=
=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot=
;,sans-serif;color:#1f497d">XY=3D# CREATE EXTENSION hstore;</span></font></=
p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri=
"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-seri=
f;color:#1f497d">ERROR:=C2=A0 type &quot;hstore&quot; already exists</span>=
</font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=
=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot=
;,sans-serif;color:#1f497d">=C2=A0</span></font></p><p class=3D"MsoNormal">=
<font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-siz=
e:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">Any idea=
s?</span></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497=
d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Calib=
ri&quot;,sans-serif;color:#1f497d">=C2=A0</span></font></p><p class=3D"MsoN=
ormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"f=
ont-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">=
=C2=A0</span></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1=
f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;C=
alibri&quot;,sans-serif;color:#1f497d">=C2=A0</span></font></p><div><div st=
yle=3D"border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm=
"><p class=3D"MsoNormal"><b><font size=3D"2" face=3D"Calibri"><span lang=3D=
"EN-US" style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-seri=
f;font-weight:bold">From:</span></font></b><font size=3D"2" face=3D"Calibri=
"><span lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:&quot;Calibri&=
quot;,sans-serif"> Tom=C3=A1=C5=A1 Uko [mailto:<a href=3D"mailto:uko@avast.=
com">uko@avast.com</a>] <br><b><span style=3D"font-weight:bold">Sent:</span=
></b> Wednesday, September 21, 2016 4:58 PM<br><b><span style=3D"font-weigh=
t:bold">To:</span></b> Payal Singh &lt;<a href=3D"mailto:payal@omniti.com">=
payal@omniti.com</a>&gt;<br><b><span style=3D"font-weight:bold">Cc:</span><=
/b> <a href=3D"mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.or=
g</a><br><b><span style=3D"font-weight:bold">Subject:</span></b> RE: [ADMIN=
] Problem with extension</span></font></p></div></div><p class=3D"MsoNormal=
"><font size=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.0pt=
">=C2=A0</span></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"=
#1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot=
;Calibri&quot;,sans-serif;color:#1f497d">Hi,</span></font></p><p class=3D"M=
soNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=
=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f49=
7d">=C2=A0</span></font></p><p class=3D"MsoNormal"><font size=3D"2" color=
=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&=
quot;Calibri&quot;,sans-serif;color:#1f497d">Sure, otherwise tables with hs=
tore column won=E2=80=99t be created/usable (IMHO). Extension is part of co=
ntrib package (if I remember correctly)</span></font></p><p class=3D"MsoNor=
mal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"fon=
t-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">=C2=
=A0</span></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f49=
7d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Cali=
bri&quot;,sans-serif;color:#1f497d">[root@XX ~]# ls -al /usr/pgsql-9.3/lib/=
hstore.so=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0</span></font></p><p class=3D"MsoNor=
mal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"fon=
t-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">-rw=
xr-xr-x 1 root root 56336 May 11 16:59 /usr/pgsql-9.3/lib/hstore.so=C2=A0=
=C2=A0 </span></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#=
1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;=
Calibri&quot;,sans-serif;color:#1f497d">=C2=A0</span></font></p><p class=3D=
"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=
=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f49=
7d">[root@XX ~]# ls -al /usr/pgsql-9.3/share/extension/hstore*</span></font=
></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Cali=
bri"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-s=
erif;color:#1f497d">-rw-r--r-- 1 root root=C2=A0=C2=A0 279 May 11 16:57 /us=
r/pgsql-9.3/share/extension/hstore--1.0--1.1.sql=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0</span></font></p><p class=
=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span st=
yle=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1=
f497d">-rw-r--r-- 1 root root=C2=A0 1201 May 11 16:57 /usr/pgsql-9.3/share/=
extension/hstore--1.1--1.2.sql=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0</span></font></p><p class=3D"MsoNormal"><fon=
t size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11=
.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">-rw-r--r-- 1=
 root root 12646 May 11 16:57 /usr/pgsql-9.3/share/extension/hstore--1.2.sq=
l =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0</span></font></p><p class=3D"MsoNormal"><fon=
t size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11=
.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">-rw-r--r-- 1=
 root root=C2=A0=C2=A0 158 May 11 16:57 /usr/pgsql-9.3/share/extension/hsto=
re.control=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0</span></font></p><p class=
=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span st=
yle=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1=
f497d">-rw-r--r-- 1 root root=C2=A0 5509 May 11 16:57 /usr/pgsql-9.3/share/=
extension/hstore--unpackaged--1.0.sql=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0</s=
pan></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" fa=
ce=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&qu=
ot;,sans-serif;color:#1f497d">=C2=A0</span></font></p><p class=3D"MsoNormal=
"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-s=
ize:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">T.</sp=
an></font></p><p class=3D"MsoNormal"><font size=3D"2" color=3D"#1f497d" fac=
e=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quo=
t;,sans-serif;color:#1f497d">=C2=A0</span></font></p><p class=3D"MsoNormal"=
><b><font size=3D"2" face=3D"Calibri"><span lang=3D"EN-US" style=3D"font-si=
ze:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;font-weight:bold">From=
:</span></font></b><font size=3D"2" face=3D"Calibri"><span lang=3D"EN-US" s=
tyle=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> Payal=
 Singh [mailto:<a href=3D"mailto:payal@omniti.com">payal@omniti.com</a>] <b=
r><b><span style=3D"font-weight:bold">Sent:</span></b> Wednesday, September=
 21, 2016 4:34 PM<br><b><span style=3D"font-weight:bold">To:</span></b> Uko=
, Tom=C3=A1=C5=A1 &lt;<a href=3D"mailto:uko@avast.com">uko@avast.com</a>&gt=
;<br><b><span style=3D"font-weight:bold">Cc:</span></b> <a href=3D"mailto:p=
gsql-admin@postgresql.org">pgsql-admin@postgresql.org</a><br><b><span style=
=3D"font-weight:bold">Subject:</span></b> Re: [ADMIN] Problem with extensio=
n</span></font></p><p class=3D"MsoNormal"><font size=3D"3" face=3D"Times Ne=
w Roman"><span style=3D"font-size:12.0pt">=C2=A0</span></font></p><div><p c=
lass=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span style=3D=
"font-size:12.0pt">On the problematic machines, do you see a hstore.so file=
 in the pgsql/lib directory?=C2=A0</span></font></p><div><p class=3D"MsoNor=
mal"><font size=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.=
0pt">=C2=A0</span></font></p></div><div><p class=3D"MsoNormal"><font size=
=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.0pt">Also, do y=
ou see hstore sql files in the pgsql/share/extension directory?=C2=A0</span=
></font></p></div></div><div><p class=3D"MsoNormal"><font size=3D"3" face=
=3D"Times New Roman"><span style=3D"font-size:12.0pt"><br clear=3D"all"></s=
pan></font></p><div><div><div><p class=3D"MsoNormal"><font size=3D"3" color=
=3D"#888888" face=3D"Helvetica"><span style=3D"font-size:12.0pt;font-family=
:&quot;Helvetica&quot;,sans-serif;color:#888888">Payal Singh,<br>Database A=
dministrator,</span></font></p><div><p class=3D"MsoNormal"><font size=3D"3"=
 color=3D"#888888" face=3D"Helvetica"><span style=3D"font-size:12.0pt;font-=
family:&quot;Helvetica&quot;,sans-serif;color:#888888">OmniTI Computer Cons=
ulting Inc.<br>Phone:=C2=A0</span></font>240.646.0770<font color=3D"#888888=
" face=3D"Helvetica"><span style=3D"font-family:&quot;Helvetica&quot;,sans-=
serif;color:#888888">=C2=A0x 253</span></font></p></div></div></div></div><=
p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span style=
=3D"font-size:12.0pt">=C2=A0</span></font></p><div><p class=3D"MsoNormal"><=
font size=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.0pt">O=
n Wed, Sep 21, 2016 at 6:09 AM, Uko, Tom=C3=A1=C5=A1 &lt;<a href=3D"mailto:=
uko@avast.com" target=3D"_blank">uko@avast.com</a>&gt; wrote:</span></font>=
</p><blockquote style=3D"border:none;border-left:solid #cccccc 1.0pt;paddin=
g:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;mar=
gin-bottom:5.0pt"><div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D=
"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New=
&quot;">Hi everybody, We have a problem with postgres extensions, we have s=
everal servers with several instances on each of them (together 42). Each o=
f those instances are same (except table names - aplication partitioning). =
But when we are preparing to migrate to newer version of Postgres, we disco=
vered this.</span></font></p></div><div><p class=3D"MsoNormal"><font size=
=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&qu=
ot;Courier New&quot;">On all servers, there are tables with hstore columns,=
 therefore there is hstore extension in use. In order to upgrade from 9.3 t=
o 9.5 we need to run &quot;ALTER EXTENSION hstore UPDATE;&quot; on each dat=
abase. But on some instances, it says, there is no extension hstore:</span>=
</font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Times=
 New Roman"><span style=3D"font-size:12.0pt">=C2=A0</span></font></p></div>=
<div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span sty=
le=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">XY=3D# alter ex=
tension hstore update;</span></font></p></div><div><p class=3D"MsoNormal"><=
font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-f=
amily:&quot;Courier New&quot;">ERROR: =C2=A0extension &quot;hstore&quot; do=
es not exist</span></font></p></div><div><p class=3D"MsoNormal"><font size=
=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.0pt">=C2=A0</sp=
an></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Co=
urier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&qu=
ot;">On &quot;correct&quot; instance \dx shows (after alter):</span></font>=
</p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"=
><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">XY=3D=
# \dx</span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" f=
ace=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Couri=
er New&quot;">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0List of installed extensions</=
span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"=
Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&=
quot;">=C2=A0 =C2=A0 Name =C2=A0 =C2=A0 | Version | =C2=A0 Schema =C2=A0 | =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Description<=
/span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D=
"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New=
&quot;">-------------+---------+------------+------------------------------=
--------------------</span></font></p></div><div><p class=3D"MsoNormal"><fo=
nt size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-fam=
ily:&quot;Courier New&quot;">=C2=A0adminpack =C2=A0 | 1.0 =C2=A0 =C2=A0 | p=
g_catalog | administrative functions for PostgreSQL</span></font></p></div>=
<div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span sty=
le=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">=C2=A0hll =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 | 1.0 =C2=A0 =C2=A0 | public =C2=A0 =C2=A0 | type =
for storing hyperloglog data</span></font></p></div><div><p class=3D"MsoNor=
mal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;=
font-family:&quot;Courier New&quot;">=C2=A0hstore =C2=A0 =C2=A0 =C2=A0| 1.2=
 =C2=A0 =C2=A0 | public =C2=A0 =C2=A0 | data type for storing sets of (key,=
 value) pairs</span></font></p></div><div><p class=3D"MsoNormal"><font size=
=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&qu=
ot;Courier New&quot;">=C2=A0pgstattuple | 1.0 =C2=A0 =C2=A0 | public =C2=A0=
 =C2=A0 | show tuple-level statistics</span></font></p></div><div><p class=
=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-si=
ze:12.0pt;font-family:&quot;Courier New&quot;">=C2=A0plpgsql =C2=A0 =C2=A0 =
| 1.0 =C2=A0 =C2=A0 | pg_catalog | PL/pgSQL procedural language</span></fon=
t></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier Ne=
w"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">(5 =
rows)</span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" f=
ace=3D"Times New Roman"><span style=3D"font-size:12.0pt">=C2=A0</span></fon=
t></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier Ne=
w"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">On =
&quot;weird&quot; one \dx shows:</span></font></p></div><div><p class=3D"Ms=
oNormal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.=
0pt;font-family:&quot;Courier New&quot;">XY=3D# \dx</span></font></p></div>=
<div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span sty=
le=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0List of installed extensions</span></font></p></div><div><p class=3D"Mso=
Normal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0=
pt;font-family:&quot;Courier New&quot;">=C2=A0 =C2=A0 Name =C2=A0 =C2=A0 | =
Version | =C2=A0 Schema =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 Description</span></font></p></div><div><p class=3D"MsoNormal"><font=
 size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-famil=
y:&quot;Courier New&quot;">-------------+---------+------------+-----------=
------------------------------</span></font></p></div><div><p class=3D"MsoN=
ormal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0p=
t;font-family:&quot;Courier New&quot;">=C2=A0adminpack =C2=A0 | 1.0 =C2=A0 =
=C2=A0 | pg_catalog | administrative functions for PostgreSQL</span></font>=
</p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"=
><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">=C2=
=A0hll =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 1.0 =C2=A0 =C2=A0 | public =C2=A0 =C2=
=A0 | type for storing hyperloglog data</span></font></p></div><div><p clas=
s=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-s=
ize:12.0pt;font-family:&quot;Courier New&quot;">=C2=A0pgstattuple | 1.0 =C2=
=A0 =C2=A0 | public =C2=A0 =C2=A0 | show tuple-level statistics</span></fon=
t></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier Ne=
w"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">=C2=
=A0plpgsql =C2=A0 =C2=A0 | 1.0 =C2=A0 =C2=A0 | pg_catalog | PL/pgSQL proced=
ural language</span></font></p></div><div><p class=3D"MsoNormal"><font size=
=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&qu=
ot;Courier New&quot;">(4 rows)</span></font></p></div><div><p class=3D"MsoN=
ormal"><font size=3D"3" face=3D"Times New Roman"><span style=3D"font-size:1=
2.0pt">=C2=A0</span></font></p></div><div><p class=3D"MsoNormal"><font size=
=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.0pt">=C2=A0</sp=
an></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Co=
urier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&qu=
ot;">We are running:</span></font></p></div><div><p class=3D"MsoNormal"><fo=
nt size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-fam=
ily:&quot;Courier New&quot;">Name =C2=A0 =C2=A0 =C2=A0 =C2=A0: postgresql93=
-server</span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3"=
 face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Cou=
rier New&quot;">Arch =C2=A0 =C2=A0 =C2=A0 =C2=A0: x86_64</span></font></p><=
/div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><spa=
n style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">Version =
=C2=A0 =C2=A0 : 9.3.13</span></font></p></div><div><p class=3D"MsoNormal"><=
font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-f=
amily:&quot;Courier New&quot;">Release =C2=A0 =C2=A0 : 1PGDG.rhel6</span></=
font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt">=C2=A0</span></font></p></div><d=
iv><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span style=
=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">On =C2=A0CentOS 6=
 2.6.32-431.20.3.el6.x86_64</span></font></p></div><div><p class=3D"MsoNorm=
al"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;f=
ont-family:&quot;Courier New&quot;">Each instance has a replica on differen=
t machine (via WAL shipping as well as streaming replication) and problem i=
s on both of them (master and slave)</span></font></p></div><div><p class=
=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span style=3D"fon=
t-size:12.0pt">=C2=A0</span></font></p></div><div><p class=3D"MsoNormal"><f=
ont size=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.0pt">=
=C2=A0</span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" =
face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Cour=
ier New&quot;">Weird is, when we try to add extension again (via CREATE EXT=
ENSION), it ends up succesfully, but \dx won&#39;t show it</span></font></p=
></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman=
"><span style=3D"font-size:12.0pt">=C2=A0</span></font></p></div><div><p cl=
ass=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span style=3D"font=
-size:12.0pt;font-family:&quot;Courier New&quot;">Another thing, when we tr=
y to add extesion with insert to pg_extension it gets OID =C2=A0far greater=
 than any other:</span></font></p></div><div><p class=3D"MsoNormal"><font s=
ize=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:=
&quot;Courier New&quot;">XY=3D# select *,pg_extension.oid from pg_extension=
;</span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=
=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier =
New&quot;">=C2=A0 =C2=A0extname =C2=A0 | extowner | extnamespace | extreloc=
atable | extversion | extconfig | extcondition | =C2=A0 =C2=A0oid</span></f=
ont></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier =
New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">-=
------------+----------+--------------+----------------+------------+------=
-----+--------------+-----------</span></font></p></div><div><p class=3D"Ms=
oNormal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.=
0pt;font-family:&quot;Courier New&quot;">=C2=A0plpgsql =C2=A0 =C2=A0 | =C2=
=A0 =C2=A0 =C2=A0 10 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 11 | f =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0| =C2=A0 =C2=A0 12617</span></font></p></div><div><p class=3D"Mso=
Normal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0=
pt;font-family:&quot;Courier New&quot;">=C2=A0adminpack =C2=A0 | =C2=A0 =C2=
=A0 =C2=A0 10 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 11 | f =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0| =C2=A0 =C2=A0 16471</span></font></p></div><div><p class=3D"MsoNormal"=
><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font=
-family:&quot;Courier New&quot;">=C2=A0hll =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =
=C2=A0 =C2=A0 =C2=A0 10 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 2200 | f =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0| =C2=A0 =C2=A0 16472</span></font></p></div><div><p class=3D"Mso=
Normal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0=
pt;font-family:&quot;Courier New&quot;">=C2=A0pgstattuple | =C2=A0 =C2=A0 =
=C2=A0 10 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 2200 | t =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0| 1.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =
=C2=A0 =C2=A0 16473</span></font></p></div><div><p class=3D"MsoNormal"><fon=
t size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-fami=
ly:&quot;Courier New&quot;">=C2=A0hstore =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=
=A0 =C2=A0 10 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 2200 | t =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0| 1.2 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 3=
66992783</span></font></p></div><div><p class=3D"MsoNormal"><font size=3D"3=
" face=3D"Times New Roman"><span style=3D"font-size:12.0pt">=C2=A0</span></=
font></p></div><div><p class=3D"MsoNormal"><font size=3D"3" face=3D"Courier=
 New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;">=
=C2=A0Any ideas what to do to fix?</span></font></p></div><div><p class=3D"=
MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span style=3D"font-si=
ze:12.0pt">=C2=A0</span></font></p></div><div><p class=3D"MsoNormal"><font =
size=3D"3" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family=
:&quot;Courier New&quot;">=C2=A0Thanks</span></font></p></div><div><p class=
=3D"MsoNormal"><font size=3D"3" face=3D"Courier New"><span style=3D"font-si=
ze:12.0pt;font-family:&quot;Courier New&quot;">=C2=A0Tomas</span></font></p=
></div></div></blockquote></div><p class=3D"MsoNormal"><font size=3D"3" fac=
e=3D"Times New Roman"><span style=3D"font-size:12.0pt">=C2=A0</span></font>=
</p></div></div></body></html>

--94eb2c092d2cbbbddc053d1661f8--