Re: Cstore_fdw issue.

Adrian,I really appreciate your help. I was able to open the file in a text editor in centOS, but it's read-only. I cannot even replace the file. Any tricks up your sleeves for me to edit this file.
Thanks
Moses 
On Friday, April 3, 2020, 12:40:19 PM EDT, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

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(at)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(dot)klaver(at)aklaver(dot)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(at)maura <mailto:aklaver(at)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com