Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dY95w-0005Zp-V9 for pgsql-performance@arkaria.postgresql.org; Thu, 20 Jul 2017 10:54:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dY95v-0006Va-Sv for pgsql-performance@arkaria.postgresql.org; Thu, 20 Jul 2017 10:54:11 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dY949-0003QW-8f for pgsql-performance@postgresql.org; Thu, 20 Jul 2017 10:52:21 +0000 Received: from mail-lf0-x22c.google.com ([2a00:1450:4010:c07::22c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dY944-0000d5-Rp for pgsql-performance@postgresql.org; Thu, 20 Jul 2017 10:52:19 +0000 Received: by mail-lf0-x22c.google.com with SMTP id g25so6732366lfh.1 for ; Thu, 20 Jul 2017 03:52:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nuxeo-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=NTINudMLng86xHN/GR/DTwb9fZv9kuO+QcqBDMjd/R8=; b=gJjIZVK5BsuoFbER6f3BJ5VRlVyw4pcewAdA8wuJevEin1Th5PwIwPE0l9Qx8VZehM aVOMCT2SCcNYqDBfstjBTr5R6jHzZUqmPSz4mTy5laiYmb2CkTHfC3Jw0AT0DlwOpoqD z8KjPKfl1PhuVsIdWQl90FaG82BSGh5D0SW4GeTlBnkY8QjK8kJ/8E/CeyM2iit5XpoK +qF5PUsSpTUNtcek6jhjcy6NEfFrSX++WsRKGvfonYcqU6OLCk3GBgjzTShL/tJv3zy8 icuQFiRglXFt/eNpbsZs6dOTOlwzzFcgLS+mdJ6O2JSOxdmOqKEMhlpV9gxT2YGX46nd UiFg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=NTINudMLng86xHN/GR/DTwb9fZv9kuO+QcqBDMjd/R8=; b=ofZ1NACqmnZE1sVgU1bUiOQSf53HfRhkk1DyMUC+Qrw4r62BGMdKexv432nVcW5Ecv KOQRqc9E19hOREORbiMkhqtz1hPZxESYIlZsdE+jUaYFQcDbKsiHcYE3aIYccAz36XV7 UJr0ET2zYL97OQnS+67NwPM7aNsxWTdOvYuRYi8JmBEvyRSuKXfT/tLAUtTiY5U85w+k a/7FXwO8g3rOVTNkyFpqXg2KnwICiYX9FCjDlmZWDbFR6bs/f5HrR+JA75p5O9/duWns Yh1HDEgrcqNxHAaZdG79Rn8oIRQDGpJ02tZwScP5L26qDvGmxMhror9Tvs6A+ZoNLk5D H0hA== X-Gm-Message-State: AIVw113G89+c8TivjAgoIANaLfw3oMzDqBowuNft3CN1nB4lXNWD44uQ EIvkHdKzn97v0c0gzua7hW/fMDH/Uj25TPs= X-Received: by 10.46.33.204 with SMTP id h73mr1169318lji.42.1500547934803; Thu, 20 Jul 2017 03:52:14 -0700 (PDT) MIME-Version: 1.0 Received: by 10.46.74.1 with HTTP; Thu, 20 Jul 2017 03:51:54 -0700 (PDT) In-Reply-To: <9b8494157c444b628ba9f982256e8173@cyient.com> References: <9b8494157c444b628ba9f982256e8173@cyient.com> From: Florent Guillaume Date: Thu, 20 Jul 2017 12:51:54 +0200 Message-ID: Subject: Re: CREATE EXTENSION postgis; To: Daulat Ram Cc: "pgsql-performance@postgresql.org" Content-Type: multipart/alternative; boundary="001a1142bfe69f6f290554bd8ade" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --001a1142bfe69f6f290554bd8ade Content-Type: text/plain; charset="UTF-8" Hi, Please use the proper list, your question is not appropriate for this list which is about PostgreSQL performance. Florent On Thu, Jul 20, 2017 at 11:05 AM, Daulat Ram wrote: > Hi team, > > > > Is this possible to create the postgis extension by *CREATE EXTENSION > postgis;* in PostgreSQL 9.1 > > > > As I know the template_postgis database is created by default during > postgis installation to support the spatial objects. > > I am getting below the error messages while creating postgis extension, > under POSTGIS="1.5.3 > > > > ERROR: could not open extension control file "/data/PostgreSQL/9.1/share/ > postgresql/extension/postgis.control": No such file or directory > > ********** Error ********** > > ERROR: could not open extension control file "/data/PostgreSQL/9.1/share/ > postgresql/extension/postgis.control": No such file or directory > > SQL state: 58P01 > > > > > > Please help on this. > > > > Regards, > > Daulat > > ------------------------------ > > DISCLAIMER: > > This email message is for the sole use of the intended recipient(s) and > may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply email and destroy > all copies of the original message. Check all attachments for viruses > before opening them. All views or opinions presented in this e-mail are > those of the author and may not reflect the opinion of Cyient or those of > our affiliates. > -- [image: Nuxeo] Florent Guillaume Head of R&D Twitter: @efge --001a1142bfe69f6f290554bd8ade Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Please use the proper list, your qu= estion is not appropriate for this list which is about PostgreSQL performan= ce.

Florent
=
On Thu, Jul 20, 2017 at 11:05 AM, Daulat Ram= <Daulat.Ram@cyient.com> wrote:

Hi team,

=C2=A0

Is this possible to create the =C2=A0postgis extensi= on by CREATE EXTENSION postgis; in PostgreSQL 9.1

=C2=A0

As I know the template_postgis database is created b= y default during postgis installation to support the spatial objects.

I am getting below the =C2=A0error messages while cr= eating postgis extension, under POSTGIS=3D"1.5.3

=C2=A0

ERROR:=C2=A0 could not op= en extension control file "/data/PostgreSQL/9.1/share/postgresql/= extension/postgis.control": No such file or directory

********** Error ********= **

ERROR: could not open ext= ension control file "/data/PostgreSQL/9.1/share/postgresql/extens= ion/postgis.control": No such file or directory

SQL state: 58P01 <= u>

=C2=A0

=C2=A0

Please help on this.

=C2=A0

Regards,

Daulat



DISCLAIMER:

This email message is for the sole use of the intended recipient(s) and may= contain confidential and privileged information. Any unauthorized review, = use, disclosure or distribution is prohibited. If you are not the intended = recipient, please contact the sender by reply email and destroy all copies of the original message. Check all a= ttachments for viruses before opening them. All views or opinions presented= in this e-mail are those of the author and may not reflect the opinion of = Cyient or those of our affiliates.



--
3D"Nuxeo"

Flore= nt Guillaume=C2=A0
Head of R&D

Tw= itter: @efge


--001a1142bfe69f6f290554bd8ade--