Re: postgres_fdw for porstgresql 9.2 installation - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: postgres_fdw for porstgresql 9.2 installation
Date
Msg-id CAGDYbUPTn7VuFzDr7FhWnHs5rbc6KomgFeK8_-z+AL13pKqnPw@mail.gmail.com
Whole thread Raw
In response to postgres_fdw for porstgresql 9.2 installation  (koff10 <koff10@hotmail.com>)
List pgsql-admin
On Sun, May 8, 2016 at 3:48 AM, koff10 <koff10@hotmail.com> wrote:

Hi all,

how to install postgres_fdw for porstgresql 9.2

I got    postgres_fwd 1.0.0.zip   on the   http://pgxn.org/dist/postgres_fdw/   web site.

Before "create extension postgres_fwd" statement  I need  to install it .

After unpacked this file I can't   run  : Make  or make install.

Thanks for your help

koff

Hi koff,

You can compile postgres_fdw using below commands, but before compile postgressql bin directory should be in your PATH variable.

PATH=/opt/PostgreSQL/9.2/bin:$PATH

USE_PGXS=1 make
USE_PGXS=1 make install

After installation you can create extension.

Hope this will help.

--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com

pgsql-admin by date:

Previous
From: koff10
Date:
Subject: postgres_fdw for porstgresql 9.2 installation
Next
From: Mark Steben
Date:
Subject: amount of WAL logs larger than expected