Re: Cstore_fdw issue. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Cstore_fdw issue.
Date
Msg-id 2d2867e3-91e9-f044-0521-25d501bb5803@aklaver.com
Whole thread Raw
In response to Re: Cstore_fdw issue.  (Moses Mafusire <mosesmafusire@yahoo.com>)
Responses Re: Cstore_fdw issue.
List pgsql-general
On 4/3/20 9:26 AM, Moses Mafusire wrote:
> Hi Adrian,
> Yes VERSION = PostgreSQL 12.1, is the only version I have. So I am 
> novice to Linux and Postgres, where should I run this
> /ifndef MAJORVERSION
>      MAJORVERSION := $(basename $(VERSION))
> endif
> $(info  MAJORVERSION is $(MAJORVERSION))/
> 
> and do I run as is or do I need to do something else, if so may you 
> please assist.

No you can't run the above by itself. In the directory you uncompressed 
the files there will be a file named Makefile. In my case:

aklaver@maura:~/test/cstore_fdw-1.7.0> ls -al

...
-rw-r--r--  1 aklaver users  1814 Apr  3 08:37 Makefile
...

Use a text editor to open that file and add the line:

$(info  MAJORVERSION is $(MAJORVERSION))

Under the section:


ifndef MAJORVERSION
     MAJORVERSION := $(basename $(VERSION))
endif

and save.

Then run:

PATH=/usr/pgsql-12/bin/:$PATH make


> 
> Thanks
> *Moses *
> 
> On Friday, April 3, 2020, 11:39:57 AM EDT, Adrian Klaver 
> <adrian.klaver@aklaver.com> wrote:
> 
> 
> On 4/3/20 5:53 AM, Moses Mafusire wrote:
>  > Hi Adrian,
>  > Thanks for your response. Here is what I'm getting when I run 
> /pg_config;/
> 
>  > VERSION = PostgreSQL 12.1
> 
> So that is the correct version.
> 
> Just to be clear there is only one version of Postgres on this machine,
> correct?
> 
> Before you run make again, edit the Makefile so:
> 
> ifndef MAJORVERSION
>      MAJORVERSION := $(basename $(VERSION))
> endif
> 
> becomes:
> 
> ifndef MAJORVERSION
>      MAJORVERSION := $(basename $(VERSION))
> endif
> $(info  MAJORVERSION is $(MAJORVERSION))
> 
> 
> When I run the above I get:
> 
> aklaver@maura <mailto:aklaver@maura>:~/test/cstore_fdw-1.7.0> 
> PATH=/usr/local/pgsql/bin/:$PATH
> make
> MAJORVERSION is 12
> 
> ...
> 
> and the code compiles.
> 
> 
> 
>  > *Moses Mafusire*
> 
> 
> 
> -- 
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Out of memory in big transactions after upgrade to 12.2
Next
From: Adrian Klaver
Date:
Subject: Re: Backing out of privilege grants rabbit hole