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