Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45864=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bn1vH-0004Gf-LM
	for pgsql-admin@arkaria.postgresql.org; Thu, 22 Sep 2016 11:12:11 +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+M45864=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bn1vH-0008Dm-8a
	for pgsql-admin@arkaria.postgresql.org; Thu, 22 Sep 2016 11:12:11 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	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 1bn1tQ-0006BY-7w
	for pgsql-admin@postgresql.org; Thu, 22 Sep 2016 11:10:16 +0000
Received: from mail-vk0-x234.google.com ([2607:f8b0:400c:c05::234])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <uko@avast.com>)
	id 1bn1tM-00085z-Ff
	for pgsql-admin@postgresql.org; Thu, 22 Sep 2016 11:10:15 +0000
Received: by mail-vk0-x234.google.com with SMTP id o139so19696092vka.2
        for <pgsql-admin@postgresql.org>;
 Thu, 22 Sep 2016 04:10:11 -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:cc;
        bh=IxD7qvRQZ4D4qgEcQejSTFyYcO6YHPKnibOa3qnsaKo=;
        b=PlhGBCmYgePjr2zLq0WvZP9CIS7xF2jxDozhBr3c4eHn84+L39GuepXiKQ2dA8gnDK
         zDLZVMeQjHQP2Edx0pnGP3W3VObtgsJwyxfygSXvBH4U1BiKfIGul2mIa/AjZ4/gdHMq
         JuunGooQrSCVOqpl/Q+pmtnDdOAFr6GzDOENoUZhN8UPAfYNPtmJVyfdGsnWI/9Jzme1
         X1cVL9GGor9SMRRHldpVtck6EAfUkTv0lBEVtEwa2gWfD1mOuJH1/e90ycsw4ONTN07B
         erRiTFouPniXlY7PnfX2bJFrifXZZuUw/i7hvtaTkTx/g8k/Avm6u436rQryPjHxA9/T
         X6SQ==
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:cc;
        bh=IxD7qvRQZ4D4qgEcQejSTFyYcO6YHPKnibOa3qnsaKo=;
        b=jGSU6yFchFhLR2O7qubvxZU/i2lq8NUpj12EzqHqkQD3SPJr4TGrUdHEdfHuOqkP71
         dHQQISZeZRvxWtBzRNNMkGZQzsVQM8HyNrPcGLpwc3oN8iVabvar7ltpMuI6RnJdcZXx
         I2fVRD3YT5PmbLZv74i9Vic3kDceXuYbhPVKOma3cnDvpFh4eNa7N+28mI+PHR4aBtH6
         XzW0HEJG3AdcUknym9IC4T/3WftoCRhitazdm7xKW/zGUQ+9an9+zo7+LvS2/osCHx3O
         T2iTvBsQ1eiRJbGs8nymFbXe4ZJ0W8xlbYjpxx7i0EZrcRe/RH+wR69YdLM44CDkVf2n
         B8wA==
X-Gm-Message-State: 
 AE9vXwOfmELXThMe1wbEAhId524pdNxUSKZbRSNDSBeNnY9GwXKBXIIGSc2Mpz6ikxPsPBKNeWDOgAEGD6Nh0LGK
X-Received: by 10.31.48.20 with SMTP id w20mr1150645vkw.5.1474542611226; Thu,
 22 Sep 2016 04:10:11 -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>,<c02d9c97c1a7ba62c221625bf063907d@mail.gmail.com>
 <BLUPR10MB05322571EFB91D02A011155ADDC90@BLUPR10MB0532.namprd10.prod.outlook.com>
In-Reply-To: 
 <BLUPR10MB05322571EFB91D02A011155ADDC90@BLUPR10MB0532.namprd10.prod.outlook.com>
MIME-Version: 1.0
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AQJeZc6q4p7G23ZWufj/ZOJoeizsWAJCsalDAuAQpvIDTWZHGwJPW+Csnxa72EA=
Date: Thu, 22 Sep 2016 13:10:09 +0200
Message-ID: <5e67f930be15a69865c814786ad27a97@mail.gmail.com>
Subject: Re: Problem with extension
To: Aislan Luiz Wendling <aislanluiz@hotmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=001a114409408c762a053d16b464
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

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

No, that doesn=E2=80=99t work as well



XY=3D# drop extension hstore;

ERROR:  extension "hstore" does not exist







*From:* Aislan Luiz Wendling [mailto:aislanluiz@hotmail.com]
*Sent:* Thursday, September 22, 2016 1:06 PM
*To:* Tom=C3=A1=C5=A1 Uko <uko@avast.com>
*Subject:* Re: [ADMIN] Problem with extension



If it is possible, you can try to drop that extension, copy the contrib
from a machine that is working and try to create again. It appears to be a
library problem with no treatment.


------------------------------

*From:* pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org>
on behalf of Tom=C3=A1=C5=A1 Uko <uko@avast.com>
*Sent:* Thursday, September 22, 2016 7:46 AM
*To:* pgsql-admin@postgresql.org
*Subject:* Re: [ADMIN] Problem with extension



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

--001a114409408c762a053d16b464
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=
=3Diso-8859-2"><meta name=3D"Generator" content=3D"Microsoft Word 15 (filte=
red medium)"><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
	{mso-style-priority:99;
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
	{mso-style-name:msonormal;
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman",serif;}
span.EmailStyle19
	{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">No, that doesn=E2=80=99t work as well</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">XY=3D#=
 drop 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;f=
ont-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">ERROR:=C2=A0 exten=
sion &quot;hstore&quot; does not exist</span></font></p><p class=3D"MsoNorm=
al"><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"#1f49=
7d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Cali=
bri&quot;,sans-serif;color:#1f497d">=C2=A0</span></font></p><p class=3D"Mso=
Normal"><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><div><div style=3D"border:none;border-top:solid #e1=
e1e1 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-serif;font-weight:bold">From:</span></font=
></b><font size=3D"2" face=3D"Calibri"><span lang=3D"EN-US" style=3D"font-s=
ize:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> Aislan Luiz Wendlin=
g [mailto:<a href=3D"mailto:aislanluiz@hotmail.com">aislanluiz@hotmail.com<=
/a>] <br><b><span style=3D"font-weight:bold">Sent:</span></b> Thursday, Sep=
tember 22, 2016 1:06 PM<br><b><span style=3D"font-weight:bold">To:</span></=
b> Tom=C3=A1=C5=A1 Uko &lt;<a href=3D"mailto:uko@avast.com">uko@avast.com</=
a>&gt;<br><b><span style=3D"font-weight:bold">Subject:</span></b> Re: [ADMI=
N] Problem with extension</span></font></p></div></div><p class=3D"MsoNorma=
l"><font size=3D"3" face=3D"Times New Roman"><span style=3D"font-size:12.0p=
t">=C2=A0</span></font></p><div id=3D"divtagdefaultwrapper"><p style=3D"bac=
kground:white"><font size=3D"3" color=3D"black" face=3D"Calibri"><span styl=
e=3D"font-size:12.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:blac=
k">If it is possible, you can try to drop that extension, copy the contrib =
from a machine that is working and try to create again. It appears to be a =
library problem with no treatment.</span></font></p><p class=3D"MsoNormal" =
style=3D"margin-bottom:12.0pt;background:white"><font size=3D"3" color=3D"b=
lack" face=3D"Calibri"><span style=3D"font-size:12.0pt;font-family:&quot;Ca=
libri&quot;,sans-serif;color:black">=C2=A0</span></font></p><div><div class=
=3D"MsoNormal" align=3D"center" style=3D"text-align:center;background:white=
"><font size=3D"3" color=3D"black" face=3D"Calibri"><span style=3D"font-siz=
e:12.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:black"><hr size=
=3D"2" width=3D"98%" align=3D"center"></span></font></div><div id=3D"divRpl=
yFwdMsg"><p class=3D"MsoNormal" style=3D"background:white"><b><font size=3D=
"2" color=3D"black" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-f=
amily:&quot;Calibri&quot;,sans-serif;color:black;font-weight:bold">From:</s=
pan></font></b><font size=3D"2" color=3D"black" face=3D"Calibri"><span styl=
e=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:blac=
k"> <a href=3D"mailto:pgsql-admin-owner@postgresql.org">pgsql-admin-owner@p=
ostgresql.org</a> &lt;<a href=3D"mailto:pgsql-admin-owner@postgresql.org">p=
gsql-admin-owner@postgresql.org</a>&gt; on behalf of Tom=C3=A1=C5=A1 Uko &l=
t;<a href=3D"mailto:uko@avast.com">uko@avast.com</a>&gt;<br><b><span style=
=3D"font-weight:bold">Sent:</span></b> Thursday, September 22, 2016 7:46 AM=
<br><b><span style=3D"font-weight:bold">To:</span></b> <a href=3D"mailto:pg=
sql-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><font color=3D"black" face=3D"Calibri"><span style=3D"font-f=
amily:&quot;Calibri&quot;,sans-serif;color:black"> </span></font></p><div><=
p class=3D"MsoNormal" style=3D"background:white"><font size=3D"3" color=3D"=
black" face=3D"Calibri"><span style=3D"font-size:12.0pt;font-family:&quot;C=
alibri&quot;,sans-serif;color:black">=C2=A0</span></font></p></div></div><d=
iv><div><p style=3D"background:white"><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">Another thing, </span></font><font color=3D"b=
lack"><span style=3D"color:black"></span></font></p><p style=3D"background:=
white"><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><font color=3D"black"><span style=3D"color:black"></spa=
n></font></p><p style=3D"background:white"><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">Recreating extension again via =E2=80=9E=
CREATE EXTENSION=E2=80=9C doesn=E2=80=99t work</span></font><font color=3D"=
black"><span style=3D"color:black"></span></font></p><p style=3D"background=
:white"><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><font color=3D"b=
lack"><span style=3D"color:black"></span></font></p><p style=3D"background:=
white"><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">E=
RROR:=C2=A0 type &quot;hstore&quot; already exists</span></font><font color=
=3D"black"><span style=3D"color:black"></span></font></p><p style=3D"backgr=
ound:white"><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">XY=3D# CREATE EXTENSION hstore;</span></font><font color=3D"black"><spa=
n style=3D"color:black"></span></font></p><p style=3D"background:white"><fo=
nt size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:1=
1.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">ERROR:=C2=
=A0 type &quot;hstore&quot; already exists</span></font><font color=3D"blac=
k"><span style=3D"color:black"></span></font></p><p style=3D"background:whi=
te"><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><font color=3D"black"><span style=3D"color:black"></span><=
/font></p><p style=3D"background:white"><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">Any ideas?</span></font><font color=3D"blac=
k"><span style=3D"color:black"></span></font></p><p style=3D"background:whi=
te"><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><font color=3D"black"><span style=3D"color:black"></span><=
/font></p><p style=3D"background:white"><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><font color=3D"black"><=
span style=3D"color:black"></span></font></p><p style=3D"background:white">=
<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">=C2=A0</=
span></font><font color=3D"black"><span style=3D"color:black"></span></font=
></p><div><div style=3D"border:none;border-top:solid #e1e1e1 1.0pt;padding:=
3.0pt 0cm 0cm 0cm"><p style=3D"background:white"><b><font size=3D"2" color=
=3D"black" face=3D"Calibri"><span lang=3D"EN-US" style=3D"font-size:11.0pt;=
font-family:&quot;Calibri&quot;,sans-serif;color:black;font-weight:bold">Fr=
om:</span></font></b><font size=3D"2" color=3D"black" face=3D"Calibri"><spa=
n lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,=
sans-serif;color:black"> 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=
-weight: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@postgre=
sql.org</a><br><b><span style=3D"font-weight:bold">Subject:</span></b> RE: =
[ADMIN] Problem with extension</span></font><font color=3D"black"><span sty=
le=3D"color:black"></span></font></p></div></div><p style=3D"background:whi=
te"><font size=3D"3" color=3D"black" face=3D"Times New Roman"><span style=
=3D"font-size:12.0pt;color:black">=C2=A0</span></font></p><p style=3D"backg=
round:white"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span styl=
e=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f4=
97d">Hi,</span></font><font color=3D"black"><span style=3D"color:black"></s=
pan></font></p><p style=3D"background:white"><font size=3D"2" color=3D"#1f4=
97d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-family:&quot;Cal=
ibri&quot;,sans-serif;color:#1f497d">=C2=A0</span></font><font color=3D"bla=
ck"><span style=3D"color:black"></span></font></p><p style=3D"background:wh=
ite"><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">Sur=
e, otherwise tables with hstore column won=E2=80=99t be created/usable (IMH=
O). Extension is part of contrib package (if I remember correctly)</span></=
font><font color=3D"black"><span style=3D"color:black"></span></font></p><p=
 style=3D"background:white"><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">=C2=A0</span></font><font color=3D"black"><span style=
=3D"color:black"></span></font></p><p style=3D"background:white"><font size=
=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;f=
ont-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">[root@XX ~]# ls -a=
l /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><=
font color=3D"black"><span style=3D"color:black"></span></font></p><p style=
=3D"background:white"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><=
span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;c=
olor:#1f497d">-rwxr-xr-x 1 root root 56336 May 11 16:59 /usr/pgsql-9.3/lib/=
hstore.so=C2=A0=C2=A0 </span></font><font color=3D"black"><span style=3D"co=
lor:black"></span></font></p><p style=3D"background:white"><font size=3D"2"=
 color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-fa=
mily:&quot;Calibri&quot;,sans-serif;color:#1f497d">=C2=A0</span></font><fon=
t color=3D"black"><span style=3D"color:black"></span></font></p><p style=3D=
"background:white"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><spa=
n style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;colo=
r:#1f497d">[root@XX ~]# ls -al /usr/pgsql-9.3/share/extension/hstore*</span=
></font><font color=3D"black"><span style=3D"color:black"></span></font></p=
><p style=3D"background:white"><font size=3D"2" color=3D"#1f497d" face=3D"C=
alibri"><span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,san=
s-serif;color:#1f497d">-rw-r--r-- 1 root root=C2=A0=C2=A0 279 May 11 16:57 =
/usr/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><font colo=
r=3D"black"><span style=3D"color:black"></span></font></p><p style=3D"backg=
round:white"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span styl=
e=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f4=
97d">-rw-r--r-- 1 root root=C2=A0 1201 May 11 16:57 /usr/pgsql-9.3/share/ex=
tension/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><font color=3D"black"><span sty=
le=3D"color:black"></span></font></p><p style=3D"background:white"><font si=
ze=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 roo=
t root 12646 May 11 16:57 /usr/pgsql-9.3/share/extension/hstore--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=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0</span></font><font color=3D"black"><span style=
=3D"color:black"></span></font></p><p style=3D"background:white"><font size=
=3D"2" color=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;f=
ont-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/hstore.con=
trol=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=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><font color=3D"blac=
k"><span style=3D"color:black"></span></font></p><p style=3D"background:whi=
te"><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">-rw-=
r--r-- 1 root root=C2=A0 5509 May 11 16:57 /usr/pgsql-9.3/share/extension/h=
store--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</span></font><=
font color=3D"black"><span style=3D"color:black"></span></font></p><p style=
=3D"background:white"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><=
span style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;c=
olor:#1f497d">=C2=A0</span></font><font color=3D"black"><span style=3D"colo=
r:black"></span></font></p><p style=3D"background:white"><font size=3D"2" c=
olor=3D"#1f497d" face=3D"Calibri"><span style=3D"font-size:11.0pt;font-fami=
ly:&quot;Calibri&quot;,sans-serif;color:#1f497d">T.</span></font><font colo=
r=3D"black"><span style=3D"color:black"></span></font></p><p style=3D"backg=
round:white"><font size=3D"2" color=3D"#1f497d" face=3D"Calibri"><span styl=
e=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f4=
97d">=C2=A0</span></font><font color=3D"black"><span style=3D"color:black">=
</span></font></p><p style=3D"background:white"><b><font size=3D"2" color=
=3D"black" face=3D"Calibri"><span lang=3D"EN-US" style=3D"font-size:11.0pt;=
font-family:&quot;Calibri&quot;,sans-serif;color:black;font-weight:bold">Fr=
om:</span></font></b><font size=3D"2" color=3D"black" face=3D"Calibri"><spa=
n lang=3D"EN-US" style=3D"font-size:11.0pt;font-family:&quot;Calibri&quot;,=
sans-serif;color:black"> Payal Singh [mailto:<a href=3D"mailto:payal@omniti=
.com">payal@omniti.com</a>] <br><b><span style=3D"font-weight:bold">Sent:</=
span></b> Wednesday, September 21, 2016 4:34 PM<br><b><span style=3D"font-w=
eight:bold">To:</span></b> Uko, Tom=C3=A1=C5=A1 &lt;<a href=3D"mailto:uko@a=
vast.com">uko@avast.com</a>&gt;<br><b><span style=3D"font-weight:bold">Cc:<=
/span></b> <a href=3D"mailto:pgsql-admin@postgresql.org">pgsql-admin@postgr=
esql.org</a><br><b><span style=3D"font-weight:bold">Subject:</span></b> Re:=
 [ADMIN] Problem with extension</span></font><font color=3D"black"><span st=
yle=3D"color:black"></span></font></p><p style=3D"background:white"><font s=
ize=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-size=
:12.0pt;color:black">=C2=A0</span></font></p><div><p style=3D"background:wh=
ite"><font size=3D"3" color=3D"black" face=3D"Times New Roman"><span style=
=3D"font-size:12.0pt;color:black">On the problematic machines, do you see a=
 hstore.so file in the pgsql/lib directory?=C2=A0</span></font></p><div><p =
style=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:black">=C2=A0</span></font>=
</p></div><div><p style=3D"background:white"><font size=3D"3" color=3D"blac=
k" face=3D"Times New Roman"><span style=3D"font-size:12.0pt;color:black">Al=
so, do you see hstore sql files in the pgsql/share/extension directory?=C2=
=A0</span></font></p></div></div><div><p style=3D"background:white"><font s=
ize=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-size=
:12.0pt;color:black"><br clear=3D"all"></span></font></p><div><div><div><p =
style=3D"background:white"><font size=3D"3" color=3D"#888888" face=3D"Helve=
tica"><span style=3D"font-size:12.0pt;font-family:&quot;Helvetica&quot;,san=
s-serif;color:#888888">Payal Singh,<br>Database Administrator,</span></font=
><font color=3D"black"><span style=3D"color:black"></span></font></p><div><=
p style=3D"background:white"><font size=3D"3" color=3D"#888888" face=3D"Hel=
vetica"><span style=3D"font-size:12.0pt;font-family:&quot;Helvetica&quot;,s=
ans-serif;color:#888888">OmniTI Computer Consulting Inc.<br>Phone:=C2=A0</s=
pan></font><font color=3D"black"><span style=3D"color:black">240.646.0770</=
span></font><font color=3D"#888888" face=3D"Helvetica"><span style=3D"font-=
family:&quot;Helvetica&quot;,sans-serif;color:#888888">=C2=A0x 253</span></=
font><font color=3D"black"><span style=3D"color:black"></span></font></p></=
div></div></div></div><p style=3D"background:white"><font size=3D"3" color=
=3D"black" face=3D"Times New Roman"><span style=3D"font-size:12.0pt;color:b=
lack">=C2=A0</span></font></p><div><p style=3D"background:white"><font size=
=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-size:12=
.0pt;color:black">On 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; w=
rote:</span></font></p><blockquote style=3D"border:none;border-left:solid #=
cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;m=
argin-right:0cm;margin-bottom:5.0pt"><div><div><p style=3D"background:white=
"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font=
-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">Hi everybody,=
 We have a problem with postgres extensions, we have several servers with s=
everal instances on each of them (together 42). Each of those instances are=
 same (except table names - aplication partitioning). But when we are prepa=
ring to migrate to newer version of Postgres, we discovered this.</span></f=
ont><font color=3D"black"><span style=3D"color:black"></span></font></p></d=
iv><div><p style=3D"background:white"><font size=3D"3" color=3D"black" face=
=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier =
New&quot;;color:black">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 &quot;ALTER EXTENSION hstore UPDATE;&quot; on each da=
tabase. But on some instances, it says, there is no extension hstore:</span=
></font><font color=3D"black"><span style=3D"color:black"></span></font></p=
></div><div><p style=3D"background:white"><font size=3D"3" color=3D"black" =
face=3D"Times New Roman"><span style=3D"font-size:12.0pt;color:black">=C2=
=A0</span></font></p></div><div><p style=3D"background:white"><font size=3D=
"3" color=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0pt;fo=
nt-family:&quot;Courier New&quot;;color:black">XY=3D# alter extension hstor=
e update;</span></font><font color=3D"black"><span style=3D"color:black"></=
span></font></p></div><div><p style=3D"background:white"><font size=3D"3" c=
olor=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-fa=
mily:&quot;Courier New&quot;;color:black">ERROR: =C2=A0extension &quot;hsto=
re&quot; does not exist</span></font><font color=3D"black"><span style=3D"c=
olor:black"></span></font></p></div><div><p style=3D"background:white"><fon=
t size=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-s=
ize:12.0pt;color:black">=C2=A0</span></font></p></div><div><p style=3D"back=
ground:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span s=
tyle=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">O=
n &quot;correct&quot; instance \dx shows (after alter):</span></font><font =
color=3D"black"><span style=3D"color:black"></span></font></p></div><div><p=
 style=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Courie=
r New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;=
color:black">XY=3D# \dx</span></font><font color=3D"black"><span style=3D"c=
olor:black"></span></font></p></div><div><p style=3D"background:white"><fon=
t size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font-size:=
12.0pt;font-family:&quot;Courier New&quot;;color:black">=C2=A0 =C2=A0 =C2=
=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><font color=3D"black=
"><span style=3D"color:black"></span></font></p></div><div><p style=3D"back=
ground:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span s=
tyle=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=
=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><font color=3D"black"><span style=3D"color:black"></span></font></p><=
/div><div><p style=3D"background:white"><font size=3D"3" color=3D"black" fa=
ce=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courie=
r New&quot;;color:black">-------------+---------+------------+-------------=
-------------------------------------</span></font><font color=3D"black"><s=
pan style=3D"color:black"></span></font></p></div><div><p style=3D"backgrou=
nd:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=
=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=C2=
=A0adminpack =C2=A0 | 1.0 =C2=A0 =C2=A0 | pg_catalog | administrative funct=
ions for PostgreSQL</span></font><font color=3D"black"><span style=3D"color=
:black"></span></font></p></div><div><p style=3D"background:white"><font si=
ze=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0=
pt;font-family:&quot;Courier New&quot;;color:black">=C2=A0hll =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 | 1.0 =C2=A0 =C2=A0 | public =C2=A0 =C2=A0 | type for storin=
g hyperloglog data</span></font><font color=3D"black"><span style=3D"color:=
black"></span></font></p></div><div><p style=3D"background:white"><font siz=
e=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0p=
t;font-family:&quot;Courier New&quot;;color:black">=C2=A0hstore =C2=A0 =C2=
=A0 =C2=A0| 1.2 =C2=A0 =C2=A0 | public =C2=A0 =C2=A0 | data type for storin=
g sets of (key, value) pairs</span></font><font color=3D"black"><span style=
=3D"color:black"></span></font></p></div><div><p style=3D"background:white"=
><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font-=
size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=C2=A0pgstattu=
ple | 1.0 =C2=A0 =C2=A0 | public =C2=A0 =C2=A0 | show tuple-level statistic=
s</span></font><font color=3D"black"><span style=3D"color:black"></span></f=
ont></p></div><div><p style=3D"background:white"><font size=3D"3" color=3D"=
black" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&qu=
ot;Courier New&quot;;color:black">=C2=A0plpgsql =C2=A0 =C2=A0 | 1.0 =C2=A0 =
=C2=A0 | pg_catalog | PL/pgSQL procedural language</span></font><font color=
=3D"black"><span style=3D"color:black"></span></font></p></div><div><p styl=
e=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Courier New=
"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color=
:black">(5 rows)</span></font><font color=3D"black"><span style=3D"color:bl=
ack"></span></font></p></div><div><p style=3D"background:white"><font size=
=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-size:12=
.0pt;color:black">=C2=A0</span></font></p></div><div><p style=3D"background=
:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=
=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">On &q=
uot;weird&quot; one \dx shows:</span></font><font color=3D"black"><span sty=
le=3D"color:black"></span></font></p></div><div><p style=3D"background:whit=
e"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"fon=
t-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">XY=3D# \dx</=
span></font><font color=3D"black"><span style=3D"color:black"></span></font=
></p></div><div><p style=3D"background:white"><font size=3D"3" color=3D"bla=
ck" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;=
Courier New&quot;;color:black">=C2=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 extension=
s</span></font><font color=3D"black"><span style=3D"color:black"></span></f=
ont></p></div><div><p style=3D"background:white"><font size=3D"3" color=3D"=
black" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&qu=
ot;Courier New&quot;;color:black">=C2=A0 =C2=A0 Name =C2=A0 =C2=A0 | Versio=
n | =C2=A0 Schema =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 Description</span></font><font color=3D"black"><span style=3D"color:black"=
></span></font></p></div><div><p style=3D"background:white"><font size=3D"3=
" color=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0pt;font=
-family:&quot;Courier New&quot;;color:black">-------------+---------+------=
------+-----------------------------------------</span></font><font color=
=3D"black"><span style=3D"color:black"></span></font></p></div><div><p styl=
e=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Courier New=
"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color=
:black">=C2=A0adminpack =C2=A0 | 1.0 =C2=A0 =C2=A0 | pg_catalog | administr=
ative functions for PostgreSQL</span></font><font color=3D"black"><span sty=
le=3D"color:black"></span></font></p></div><div><p style=3D"background:whit=
e"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"fon=
t-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=C2=A0hll =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 1.0 =C2=A0 =C2=A0 | public =C2=A0 =C2=A0 | ty=
pe for storing hyperloglog data</span></font><font color=3D"black"><span st=
yle=3D"color:black"></span></font></p></div><div><p style=3D"background:whi=
te"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"fo=
nt-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=C2=A0pgsta=
ttuple | 1.0 =C2=A0 =C2=A0 | public =C2=A0 =C2=A0 | show tuple-level statis=
tics</span></font><font color=3D"black"><span style=3D"color:black"></span>=
</font></p></div><div><p style=3D"background:white"><font size=3D"3" color=
=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family=
:&quot;Courier New&quot;;color:black">=C2=A0plpgsql =C2=A0 =C2=A0 | 1.0 =C2=
=A0 =C2=A0 | pg_catalog | PL/pgSQL procedural language</span></font><font c=
olor=3D"black"><span style=3D"color:black"></span></font></p></div><div><p =
style=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Courier=
 New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;c=
olor:black">(4 rows)</span></font><font color=3D"black"><span style=3D"colo=
r:black"></span></font></p></div><div><p style=3D"background:white"><font s=
ize=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-size=
:12.0pt;color:black">=C2=A0</span></font></p></div><div><p style=3D"backgro=
und:white"><font size=3D"3" color=3D"black" face=3D"Times New Roman"><span =
style=3D"font-size:12.0pt;color:black">=C2=A0</span></font></p></div><div><=
p style=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Couri=
er New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;=
;color:black">We are running:</span></font><font color=3D"black"><span styl=
e=3D"color:black"></span></font></p></div><div><p style=3D"background:white=
"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font=
-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">Name =C2=A0 =
=C2=A0 =C2=A0 =C2=A0: postgresql93-server</span></font><font color=3D"black=
"><span style=3D"color:black"></span></font></p></div><div><p style=3D"back=
ground:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span s=
tyle=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">A=
rch =C2=A0 =C2=A0 =C2=A0 =C2=A0: x86_64</span></font><font color=3D"black">=
<span style=3D"color:black"></span></font></p></div><div><p style=3D"backgr=
ound:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span sty=
le=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">Ver=
sion =C2=A0 =C2=A0 : 9.3.13</span></font><font color=3D"black"><span style=
=3D"color:black"></span></font></p></div><div><p style=3D"background:white"=
><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font-=
size:12.0pt;font-family:&quot;Courier New&quot;;color:black">Release =C2=A0=
 =C2=A0 : 1PGDG.rhel6</span></font><font color=3D"black"><span style=3D"col=
or:black"></span></font></p></div><div><p style=3D"background:white"><font =
size=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-siz=
e:12.0pt;color:black">=C2=A0</span></font></p></div><div><p style=3D"backgr=
ound:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span sty=
le=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">On =
=C2=A0CentOS 6 2.6.32-431.20.3.el6.x86_64</span></font><font color=3D"black=
"><span style=3D"color:black"></span></font></p></div><div><p style=3D"back=
ground:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span s=
tyle=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">E=
ach instance has a replica on different machine (via WAL shipping as well a=
s streaming replication) and problem is on both of them (master and slave)<=
/span></font><font color=3D"black"><span style=3D"color:black"></span></fon=
t></p></div><div><p style=3D"background:white"><font size=3D"3" color=3D"bl=
ack" face=3D"Times New Roman"><span style=3D"font-size:12.0pt;color:black">=
=C2=A0</span></font></p></div><div><p style=3D"background:white"><font size=
=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-size:12=
.0pt;color:black">=C2=A0</span></font></p></div><div><p style=3D"background=
:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=
=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">Weird=
 is, when we try to add extension again (via CREATE EXTENSION), it ends up =
succesfully, but \dx won&#39;t show it</span></font><font color=3D"black"><=
span style=3D"color:black"></span></font></p></div><div><p style=3D"backgro=
und:white"><font size=3D"3" color=3D"black" face=3D"Times New Roman"><span =
style=3D"font-size:12.0pt;color:black">=C2=A0</span></font></p></div><div><=
p style=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Couri=
er New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;=
;color:black">Another thing, when we try to add extesion with insert to pg_=
extension it gets OID =C2=A0far greater than any other:</span></font><font =
color=3D"black"><span style=3D"color:black"></span></font></p></div><div><p=
 style=3D"background:white"><font size=3D"3" color=3D"black" face=3D"Courie=
r New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;=
color:black">XY=3D# select *,pg_extension.oid from pg_extension;</span></fo=
nt><font color=3D"black"><span style=3D"color:black"></span></font></p></di=
v><div><p style=3D"background:white"><font size=3D"3" color=3D"black" face=
=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier =
New&quot;;color:black">=C2=A0 =C2=A0extname =C2=A0 | extowner | extnamespac=
e | extrelocatable | extversion | extconfig | extcondition | =C2=A0 =C2=A0o=
id</span></font><font color=3D"black"><span style=3D"color:black"></span></=
font></p></div><div><p style=3D"background:white"><font size=3D"3" color=3D=
"black" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&q=
uot;Courier New&quot;;color:black">-------------+----------+--------------+=
----------------+------------+-----------+--------------+-----------</span>=
</font><font color=3D"black"><span style=3D"color:black"></span></font></p>=
</div><div><p style=3D"background:white"><font size=3D"3" color=3D"black" f=
ace=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Couri=
er New&quot;;color:black">=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><font color=3D"black"><span style=3D"color=
:black"></span></font></p></div><div><p style=3D"background:white"><font si=
ze=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0=
pt;font-family:&quot;Courier New&quot;;color:black">=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><font color=3D"black"><=
span style=3D"color:black"></span></font></p></div><div><p style=3D"backgro=
und:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span styl=
e=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=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><font color=3D"black"><span style=3D"color:black"></span></font></p></=
div><div><p style=3D"background:white"><font size=3D"3" color=3D"black" fac=
e=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quot;Courier=
 New&quot;;color:black">=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><font color=3D"black"><span style=3D"color:black"></span></fo=
nt></p></div><div><p style=3D"background:white"><font size=3D"3" color=3D"b=
lack" face=3D"Courier New"><span style=3D"font-size:12.0pt;font-family:&quo=
t;Courier New&quot;;color:black">=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| 366992783</span></font><font color=3D"black"><span style=3D"color:blac=
k"></span></font></p></div><div><p style=3D"background:white"><font size=3D=
"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-size:12.0p=
t;color:black">=C2=A0</span></font></p></div><div><p style=3D"background:wh=
ite"><font size=3D"3" color=3D"black" face=3D"Courier New"><span style=3D"f=
ont-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=C2=A0Any =
ideas what to do to fix?</span></font><font color=3D"black"><span style=3D"=
color:black"></span></font></p></div><div><p style=3D"background:white"><fo=
nt size=3D"3" color=3D"black" face=3D"Times New Roman"><span style=3D"font-=
size:12.0pt;color:black">=C2=A0</span></font></p></div><div><p style=3D"bac=
kground:white"><font size=3D"3" color=3D"black" face=3D"Courier New"><span =
style=3D"font-size:12.0pt;font-family:&quot;Courier New&quot;;color:black">=
=C2=A0Thanks</span></font><font color=3D"black"><span style=3D"color:black"=
></span></font></p></div><div><p style=3D"background:white"><font size=3D"3=
" color=3D"black" face=3D"Courier New"><span style=3D"font-size:12.0pt;font=
-family:&quot;Courier New&quot;;color:black">=C2=A0Tomas</span></font><font=
 color=3D"black"><span style=3D"color:black"></span></font></p></div></div>=
</blockquote></div><p style=3D"background:white"><font size=3D"3" color=3D"=
black" face=3D"Times New Roman"><span style=3D"font-size:12.0pt;color:black=
">=C2=A0</span></font></p></div></div></div></div></div></div></body></html=
>

--001a114409408c762a053d16b464--