Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1jqC2Y-0002Km-4c
	for pgsql-admin@arkaria.postgresql.org; Tue, 30 Jun 2020 08:54:54 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1jqC2X-0005Ur-2Q
	for pgsql-admin@arkaria.postgresql.org; Tue, 30 Jun 2020 08:54:53 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <jana.mihalidesova@cetin.cz>)
	id 1jqC2W-0005Rp-MK
	for pgsql-admin@lists.postgresql.org; Tue, 30 Jun 2020 08:54:52 +0000
Received: from smtp01.cetin.cz ([85.162.10.10])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <jana.mihalidesova@cetin.cz>)
	id 1jqC2T-0003Se-CA
	for pgsql-admin@postgresql.org; Tue, 30 Jun 2020 08:54:51 +0000
Received: from celsmtp402.server.cetin (celsmtp402.server.cetin
 [172.29.128.39])
	by smtp01.cetin.cz (Postfix) with ESMTP id B0BAB80089
	for <pgsql-admin@postgresql.org>; Tue, 30 Jun 2020 10:54:46 +0200 (CEST)
Received: from CEWAEXCHP401.ad.cetin (autodiscover.cetin.cz [172.29.130.15])
	by celsmtp402.server.cetin (Postfix) with ESMTP id ACE91780050
	for <pgsql-admin@postgresql.org>; Tue, 30 Jun 2020 10:54:46 +0200 (CEST)
Received: from CEWAEXCHP402.ad.cetin (172.29.130.16) by CEWAEXCHP401.ad.cetin
 (172.29.130.15) with Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA) id 15.2.595.3; Tue, 30 Jun 2020
 10:54:46 +0200
Received: from CEWAEXCHP402.ad.cetin ([fe80::888e:fb8b:8b03:1de3]) by
 CEWAEXCHP402.ad.cetin ([fe80::888e:fb8b:8b03:1de3%8]) with mapi id
 15.02.0595.003; Tue, 30 Jun 2020 10:54:46 +0200
From: =?iso-8859-2?Q?Mihalidesov=E1_Jana?= <jana.mihalidesova@cetin.cz>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Create extention CITEX failed
Thread-Topic: Create extention CITEX failed
Thread-Index: AdZOu1FWn18gQWzwRfyv/ZK90e0P8Q==
Date: Tue, 30 Jun 2020 08:54:46 +0000
Message-ID: <fb138136a04143e29e708ecfb571a16b@cetin.cz>
Accept-Language: en-US, cs-CZ
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-originating-ip: [172.24.123.187]
Content-Type: multipart/alternative;
	boundary="_000_fb138136a04143e29e708ecfb571a16bcetincz_"
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

--_000_fb138136a04143e29e708ecfb571a16bcetincz_
Content-Type: text/plain; charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hi,

I unzip the binaries for postgresl 12.2 on server. There is a directory .. =
/postgresql-12.2/contrib with list of possible extentions. Then I installed=
 postgres using

configure --prefix=3D/pgsql/bin/<version>_<db_name>
make
make install

then I created database


pg_ctl -D /<path> initdb


Now I try to create extention but I got error

clooneyt=3D# CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
ERROR:  could not open extension control file "/pgsql/bin/12.2_clooneyt/sha=
re/extension/citext.control": No such file or directory


And really there's no citext.control file. How I install/create extention C=
ITEX.

Thanks,

JM



Obsah t=E9to zpr=E1vy m=E1 v=FDlu=E8n=EC komunika=E8n=ED charakter. Nep=F8e=
dstavuje n=E1vrh na uzav=F8en=ED smlouvy =E8i na jej=ED zm=ECnu ani p=F8ije=
t=ED p=F8=EDpadn=E9ho n=E1vrhu. Smlouvy =E8i jejich zm=ECny jsou spole=E8no=
st=ED CETIN a.s. uzav=EDr=E1ny v p=EDsemn=E9 form=EC nebo v podob=EC a post=
upem podle p=F8=EDslu=B9n=FDch v=B9eobecn=FDch podm=EDnek spole=E8nosti CET=
IN a.s., a pokud jsou dohodnuty v=B9echny n=E1le=BEitosti. Smlouvy jsou uza=
v=EDr=E1ny opr=E1vn=ECnou osobou na z=E1klad=EC p=EDsemn=E9ho pov=EC=F8en=
=ED. Smlouvy o smlouv=EC budouc=ED jsou uzav=EDr=E1ny v=FDhradn=EC v p=EDse=
mn=E9 form=EC, vlastnoru=E8n=EC podepsan=E9 nebo s uzn=E1van=FDm elektronic=
k=FDm podpisem. Podm=EDnky, za nich=BE CETIN a.s. p=F8istupuje k jedn=E1n=
=ED o smlouv=EC a jak=FDmi se =F8=EDd=ED, jsou dostupn=E9 zde<https://www.c=
etin.cz/cs/jak-cetin-vyjednava-o-smlouve>.

The content of this message is intended for communication purposes only. It=
 does neither represent any contract proposal, nor its amendment or accepta=
nce of any potential contract proposal. CETIN a.s. concludes contracts or a=
mendments thereto in a written form or in the form and the procedure in acc=
ordance with relevant general terms and conditions of CETIN a.s., if all re=
quirements are agreed. Contracts are concluded by an authorized person enti=
tled on the basis of a written authorization. Contracts on a future contrac=
t are concluded solely in a written form, self-signed or signed by means of=
 an advanced electronic signature. The conditions under which CETIN a.s. ne=
gotiates contracts and under which it proceeds are available here<https://w=
ww.cetin.cz/en/jak-cetin-vyjednava-o-smlouve>.

--_000_fb138136a04143e29e708ecfb571a16bcetincz_
Content-Type: text/html; charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
2">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
pre
	{mso-style-priority:99;
	mso-style-link:"HTML Preformatted Char";
	margin:0cm;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Courier New";}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
span.HTMLPreformattedChar
	{mso-style-name:"HTML Preformatted Char";
	mso-style-priority:99;
	mso-style-link:"HTML Preformatted";
	font-family:"Courier New";}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I unzip the binaries for postgresl 12.2 on server. T=
here is a directory .. /postgresql-12.2/contrib with list of possible exten=
tions. Then I installed postgres using
<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<div style=3D"mso-element:para-border-div;border:dashed #CCCCCC 1.0pt;paddi=
ng:6.0pt 6.0pt 6.0pt 6.0pt;background:#F7F9FA">
<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt;text-align:justify;bac=
kground:#F7F9FA;border:none;padding:0cm">
<span style=3D"font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#=
333333">configure --prefix=3D/pgsql/bin/&lt;version&gt;_&lt;db_name&gt;<o:p=
></o:p></span></p>
</div>
<p class=3D"MsoNormal">make <o:p></o:p></p>
<p class=3D"MsoNormal">make install<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">then I created database<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<div style=3D"mso-element:para-border-div;border:dashed #CCCCCC 1.0pt;paddi=
ng:6.0pt 6.0pt 6.0pt 6.0pt;background:#F7F9FA">
<pre style=3D"margin-bottom:12.0pt;text-align:justify;background:#F7F9FA;bo=
rder:none;padding:0cm"><span style=3D"color:#333333">pg_ctl -D /&lt;path&gt=
; initdb<o:p></o:p></span></pre>
</div>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Now I try to create extention but I got error<o:p></=
o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">clooneyt=3D# CREATE EXTENSION IF NOT EXISTS citext W=
ITH SCHEMA public;<o:p></o:p></p>
<p class=3D"MsoNormal">ERROR:&nbsp; could not open extension control file &=
quot;/pgsql/bin/12.2_clooneyt/share/extension/citext.control&quot;: No such=
 file or directory<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">And really there&#8217;s no citext.control file. How=
 I install/create extention CITEX.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-autospace:none">JM<span style=3D"font-=
size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:#929497"><o:p></=
o:p></span></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<br>
<br>
<font size=3D"-2">Obsah t=E9to zpr=E1vy m=E1 v=FDlu=E8n=EC komunika=E8n=ED =
charakter. Nep=F8edstavuje n=E1vrh na uzav=F8en=ED smlouvy =E8i na jej=ED z=
m=ECnu ani p=F8ijet=ED p=F8=EDpadn=E9ho n=E1vrhu. Smlouvy =E8i jejich zm=EC=
ny jsou spole=E8nost=ED CETIN a.s. uzav=EDr=E1ny v p=EDsemn=E9 form=EC nebo=
 v podob=EC a postupem
 podle p=F8=EDslu=B9n=FDch v=B9eobecn=FDch podm=EDnek spole=E8nosti CETIN a=
.s., a pokud jsou dohodnuty v=B9echny n=E1le=BEitosti. Smlouvy jsou uzav=ED=
r=E1ny opr=E1vn=ECnou osobou na z=E1klad=EC p=EDsemn=E9ho pov=EC=F8en=ED. S=
mlouvy o smlouv=EC budouc=ED jsou uzav=EDr=E1ny v=FDhradn=EC v p=EDsemn=E9 =
form=EC, vlastnoru=E8n=EC
 podepsan=E9 nebo s uzn=E1van=FDm elektronick=FDm podpisem. Podm=EDnky, za =
nich=BE CETIN a.s. p=F8istupuje k jedn=E1n=ED o smlouv=EC a jak=FDmi se =F8=
=EDd=ED, jsou dostupn=E9
<a href=3D"https://www.cetin.cz/cs/jak-cetin-vyjednava-o-smlouve">zde</a>.<=
br>
<br>
The content of this message is intended for communication purposes only. It=
 does neither represent any contract proposal, nor its amendment or accepta=
nce of any potential contract proposal. CETIN a.s. concludes contracts or a=
mendments thereto in a written form
 or in the form and the procedure in accordance with relevant general terms=
 and conditions of CETIN a.s., if all requirements are agreed. Contracts ar=
e concluded by an authorized person entitled on the basis of a written auth=
orization. Contracts on a future
 contract are concluded solely in a written form, self-signed or signed by =
means of an advanced electronic signature. The conditions under which CETIN=
 a.s. negotiates contracts and under which it proceeds are available
<a href=3D"https://www.cetin.cz/en/jak-cetin-vyjednava-o-smlouve">here</a>.=
</font>
</body>
</html>

--_000_fb138136a04143e29e708ecfb571a16bcetincz_--