Обсуждение: How can i install contrib modules in pg11 via source

Поиск
Список
Период
Сортировка

How can i install contrib modules in pg11 via source

От
Márcio Antônio Sepp
Дата:

 

Hi all,

 

 

How can i install contrib modules in pg11. I’m using FreeBSD 11.2.

In specific i need to install hstore for test purpose.

 

Thanks in advance.

 

 

--

Att

Márcio A. Sepp

 

Re: How can i install contrib modules in pg11 via source

От
Adrian Klaver
Дата:
On 07/24/2018 12:00 PM, Márcio Antônio Sepp wrote:
> Hi all,
> 
> How can i install contrib modules in pg11. I’m using FreeBSD 11.2.
> 
> In specific i need to install hstore for test purpose.

To confirm you are building from source correct?

If so I can tell you how I do it in Linux and you can make the 
appropriate translations to BSD.

1) cd to contrib/hstore/

2) make

3) sudo make install

4) In psql CREATE EXTENSION hstore;

> 
> Thanks in advance.
> 
> --
> 
> Att
> 
> Márcio A. Sepp
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

RES: How can i install contrib modules in pg11 via source

От
Márcio Antônio Sepp
Дата:
> 
> If so I can tell you how I do it in Linux and you can make the
> appropriate translations to BSD.
> 
> 1) cd to contrib/hstore/
> 
> 2) make
> 
> 3) sudo make install
> 
> 4) In psql CREATE EXTENSION hstore;

Well, I allways install via pkg and I didn't find the contrib folder  (: 

Now, the follow error message occur:

root@pg11:/pg11/postgresql-11beta2/contrib/hstore # make
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 16: Need an
operator
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 19: Could not
find
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 20: Need an
operator
make: "../../src/../../src/Makefile.global" line 44: Need an operator
make: "../../src/../../src/Makefile.global" line 49: Need an operator
make: "../../src/../../src/Makefile.global" line 51: Need an operator
make: "../../src/../../src/Makefile.global" line 52: Missing dependency
operator
make: "../../src/../../src/Makefile.global" line 55: Need an operator
make: "../../src/../../src/Makefile.global" line 58: Need an operator
make: "../../src/../../src/Makefile.global" line 59: Need an operator
make: "../../src/../../src/Makefile.global" line 60: Need an operator
make: "../../src/../../src/Makefile.global" line 65: Missing dependency
operator
make: "../../src/../../src/Makefile.global" line 68: Need an operator
make: "../../src/../../src/Makefile.global" line 72: Need an operator
make: "../../src/../../src/Makefile.global" line 73: Need an operator
make: "../../src/../../src/Makefile.global" line 93: Need an operator
make: "../../src/../../src/Makefile.global" line 105: Need an operator
make: "../../src/../../src/Makefile.global" line 106: Need an operator
make: "../../src/../../src/Makefile.global" line 108: Need an operator
make: "../../src/../../src/Makefile.global" line 109: Need an operator
make: "../../src/../../src/Makefile.global" line 112: Need an operator
make: "../../src/../../src/Makefile.global" line 113: Need an operator
make: "../../src/../../src/Makefile.global" line 115: Need an operator
make: "../../src/../../src/Makefile.global" line 116: Need an operator
make: "../../src/../../src/Makefile.global" line 121: Need an operator
make: "../../src/../../src/Makefile.global" line 122: Need an operator
make: "../../src/../../src/Makefile.global" line 124: Need an operator
make: "../../src/../../src/Makefile.global" line 125: Need an operator
make: "../../src/../../src/Makefile.global" line 130: Need an operator
make: "../../src/../../src/Makefile.global" line 131: Need an operator
make: "../../src/../../src/Makefile.global" line 133: Need an operator
make: "../../src/../../src/Makefile.global" line 134: Need an operator
make: "../../src/../../src/Makefile.global" line 139: Need an operator
make: "../../src/../../src/Makefile.global" line 140: Need an operator
make: "../../src/../../src/Makefile.global" line 142: Need an operator
make: "../../src/../../src/Makefile.global" line 143: Need an operator
make: "../../src/../../src/Makefile.global" line 149: Need an operator
make: "../../src/../../src/Makefile.global" line 152: Need an operator
...

Re: How can i install contrib modules in pg11 via source

От
"Joshua D. Drake"
Дата:
On 07/24/2018 12:08 PM, Adrian Klaver wrote:
> On 07/24/2018 12:00 PM, Márcio Antônio Sepp wrote:
>> Hi all,
>>
>> How can i install contrib modules in pg11. I’m using FreeBSD 11.2.
>>
>> In specific i need to install hstore for test purpose.
>
> To confirm you are building from source correct?
>
> If so I can tell you how I do it in Linux and you can make the 
> appropriate translations to BSD.
>

0) ./configure;


> 1) cd to contrib/hstore/
>
> 2) make
>
> 3) sudo make install
>
> 4) In psql CREATE EXTENSION hstore;
>
>>
>> Thanks in advance.
>>
>> -- 
>>
>> Att
>>
>> Márcio A. Sepp
>>
>
>

-- 
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
***  A fault and talent of mine is to tell it exactly how it is.  ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
*****     Unless otherwise stated, opinions are my own.   *****

Re: How can i install contrib modules in pg11 via source

От
Olivier Gautherot
Дата:

On Tue, Jul 24, 2018 at 3:41 PM, Márcio Antônio Sepp <marcio@zyontecnologia.com.br> wrote:
>
> If so I can tell you how I do it in Linux and you can make the
> appropriate translations to BSD.
>
> 1) cd to contrib/hstore/
>
> 2) make
>
> 3) sudo make install
>
> 4) In psql CREATE EXTENSION hstore;

Well, I allways install via pkg and I didn't find the contrib folder  (:

Now, the follow error message occur:

root@pg11:/pg11/postgresql-11beta2/contrib/hstore # make
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 16: Need an
operator
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 19: Could not
find
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 20: Need an
operator


Márcio, remember that it is FreeBSD, not Linux.
Use gmake (GNU make) instead of make (BSD make). They are not compatible...

RES: How can i install contrib modules in pg11 via source

От
Márcio Antônio Sepp
Дата:


root@pg11:/pg11/postgresql-11beta2/contrib/hstore # make
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 16: Need an
operator
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 19: Could not
find
make: "/pg11/postgresql-11beta2/contrib/hstore/Makefile" line 20: Need an
operator

 

Márcio, remember that it is FreeBSD, not Linux.

Use gmake (GNU make) instead of make (BSD make). They are not compatible...

 

Thank you so much. Now it’s ok.

 

Commands:  gmake;  gmake install; create extension hstore;

 

Thanks so much.