Thread: postgres_fdw for porstgresql 9.2 installation

postgres_fdw for porstgresql 9.2 installation

From
koff10
Date:

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


			
		

Re: postgres_fdw for porstgresql 9.2 installation

From
Shreeyansh Dba
Date:
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