Re: Cstore_fdw issue. - Mailing list pgsql-general

From Moses Mafusire
Subject Re: Cstore_fdw issue.
Date
Msg-id 1416529272.8976.1585936092215@mail.yahoo.com
Whole thread Raw
In response to Re: Cstore_fdw issue.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Cstore_fdw issue.
List pgsql-general
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.klaver@aklaver.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@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>

pgsql-general by date:

Previous
From: AC Gomez
Date:
Subject: Re: Backing out of privilege grants rabbit hole
Next
From: Adrian Klaver
Date:
Subject: Re: Cstore_fdw issue.