Subject: Re: Create extention CITEX failed
To: =?UTF-8?Q?Mihalidesov=c3=a1_Jana?= <jana.mihalidesova@cetin.cz>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
References: <fb138136a04143e29e708ecfb571a16b@cetin.cz>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <095ea106-5a4b-baec-79d3-7b3ba5fafca8@2ndquadrant.com>
Date: Tue, 30 Jun 2020 11:40:47 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <fb138136a04143e29e708ecfb571a16b@cetin.cz>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk

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