Re: postgres_fdw for porstgresql 9.2 installation

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: koff10 <koff10(at)hotmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres_fdw for porstgresql 9.2 installation
Date: 2016-05-09 05:24:09
Message-ID: CAGDYbUPTn7VuFzDr7FhWnHs5rbc6KomgFeK8_-z+AL13pKqnPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, May 8, 2016 at 3:48 AM, koff10 <koff10(at)hotmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Steben 2016-05-09 18:23:49 amount of WAL logs larger than expected
Previous Message koff10 2016-05-07 22:18:35 postgres_fdw for porstgresql 9.2 installation