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