Обсуждение: How can i install contrib modules in pg11 via source
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
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
> > 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 ...
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. *****
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...
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.