Обсуждение: postgres_fdw for porstgresql 9.2 installation

Поиск
Список
Период
Сортировка

postgres_fdw for porstgresql 9.2 installation

От
koff10
Дата:

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

									
		    

		        
От
 
		    	
Shreeyansh Dba

		    

		    

		        
Дата:

		        




			

		

	

	
							
						
	

	

		

			
				
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