pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Create extention CITEX failed
3+ messages / 2 participants
[nested] [flat]

* Create extention CITEX failed
@ 2020-06-30 08:54 Mihalidesová Jana <jana.mihalidesova@cetin.cz>
  2020-06-30 09:40 ` Re: Create extention CITEX failed Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
  2020-06-30 12:01 ` RE: Create extention CITEX failed Mihalidesová Jana <jana.mihalidesova@cetin.cz>
  0 siblings, 2 replies; 3+ messages in thread

From: Mihalidesová Jana @ 2020-06-30 08:54 UTC (permalink / raw)
  To: pgsql-admin

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=/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=# CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
ERROR:  could not open extension control file "/pgsql/bin/12.2_clooneyt/share/extension/citext.control": No such file or directory


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

Thanks,

JM



Obsah této zprávy má výlučně komunikační charakter. Nepředstavuje návrh na uzavření smlouvy či na její změnu ani přijetí případného návrhu. Smlouvy či jejich změny jsou společností CETIN a.s. uzavírány v písemné formě nebo v podobě a postupem podle příslušných všeobecných podmínek společnosti CETIN a.s., a pokud jsou dohodnuty všechny náležitosti. Smlouvy jsou uzavírány oprávněnou osobou na základě písemného pověření. Smlouvy o smlouvě budoucí jsou uzavírány výhradně v písemné formě, vlastnoručně podepsané nebo s uznávaným elektronickým podpisem. Podmínky, za nichž CETIN a.s. přistupuje k jednání o smlouvě a jakými se řídí, jsou dostupné zde<https://www.cetin.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 acceptance of any potential contract proposal. CETIN a.s. concludes contracts or amendments 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 are concluded by an authorized person entitled on the basis of a written authorization. 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 here<https://www.cetin.cz/en/jak-cetin-vyjednava-o-smlouve;.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Create extention CITEX failed
  2020-06-30 08:54 Create extention CITEX failed Mihalidesová Jana <jana.mihalidesova@cetin.cz>
@ 2020-06-30 09:40 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2020-06-30 09:40 UTC (permalink / raw)
  To: Mihalidesová Jana <jana.mihalidesova@cetin.cz>; pgsql-admin

On 2020-06-30 10:54, Mihalidesová Jana wrote:
> 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=/pgsql/bin/<version>_<db_name>
> 
> make
> 
> make install

You need to run make install-world or make -C contrib install to install 
contrib modules from source.

> 
> then I created database
> 
> pg_ctl -D /<path> initdb
> 
> Now I try to create extention but I got error
> 
> clooneyt=# CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
> 
> ERROR:  could not open extension control file 
> "/pgsql/bin/12.2_clooneyt/share/extension/citext.control": No such file 
> or directory
> 
> And really there’s no citext.control file. How I install/create 
> extention CITEX.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: Create extention CITEX failed
  2020-06-30 08:54 Create extention CITEX failed Mihalidesová Jana <jana.mihalidesova@cetin.cz>
@ 2020-06-30 12:01 ` Mihalidesová Jana <jana.mihalidesova@cetin.cz>
  1 sibling, 0 replies; 3+ messages in thread

From: Mihalidesová Jana @ 2020-06-30 12:01 UTC (permalink / raw)
  To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; pgsql-admin

Hi,

Thanks a lot I already figured it out.

Jana

-----Original Message-----
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Sent: Tuesday, June 30, 2020 11:41 AM
To: Mihalidesová Jana <jana.mihalidesova@cetin.cz>; pgsql-admin@postgresql.org
Subject: Re: Create extention CITEX failed


On 2020-06-30 10:54, Mihalidesová Jana wrote:
> 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=/pgsql/bin/<version>_<db_name>
>
> make
>
> make install

You need to run make install-world or make -C contrib install to install contrib modules from source.

>
> then I created database
>
> pg_ctl -D /<path> initdb
>
> Now I try to create extention but I got error
>
> clooneyt=# CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
>
> ERROR:  could not open extension control file
> "/pgsql/bin/12.2_clooneyt/share/extension/citext.control": No such
> file or directory
>
> And really there’s no citext.control file. How I install/create
> extention CITEX.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


Obsah této zprávy má výlučně komunikační charakter. Nepředstavuje návrh na uzavření smlouvy či na její změnu ani přijetí případného návrhu. Smlouvy či jejich změny jsou společností CETIN a.s. uzavírány v písemné formě nebo v podobě a postupem podle příslušných všeobecných podmínek společnosti CETIN a.s., a pokud jsou dohodnuty všechny náležitosti. Smlouvy jsou uzavírány oprávněnou osobou na základě písemného pověření. Smlouvy o smlouvě budoucí jsou uzavírány výhradně v písemné formě, vlastnoručně podepsané nebo s uznávaným elektronickým podpisem. Podmínky, za nichž CETIN a.s. přistupuje k jednání o smlouvě a jakými se řídí, jsou dostupné zde<https://www.cetin.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 acceptance of any potential contract proposal. CETIN a.s. concludes contracts or amendments 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 are concluded by an authorized person entitled on the basis of a written authorization. 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 here<https://www.cetin.cz/en/jak-cetin-vyjednava-o-smlouve;.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2020-06-30 12:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-06-30 08:54 Create extention CITEX failed Mihalidesová Jana <jana.mihalidesova@cetin.cz>
2020-06-30 09:40 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2020-06-30 12:01 ` Mihalidesová Jana <jana.mihalidesova@cetin.cz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox