From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Moses Mafusire <mosesmafusire(at)yahoo(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Cstore_fdw issue. |
Date: | 2020-04-03 16:39:50 |
Message-ID: | 2d2867e3-91e9-f044-0521-25d501bb5803@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-04-03 17:18:09 | Re: Backing out of privilege grants rabbit hole |
Previous Message | Michael Lewis | 2020-04-03 16:30:28 | Re: Out of memory in big transactions after upgrade to 12.2 |