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