Solved

How to add postgresql 9.2 extensions in windows seven ?

Posted on 2012-12-20
6
2,330 Views
Last Modified: 2013-01-14
Hello experts,

my goal is : i'd like to use dblink_connect() function,

--- situation ---- -
i have an installation of pgsql 9.2 on my seven computer.

i've google and i 'm supposed to have packages in
C:\Program Files\PostgreSQL\9.2\share\contrib\
but my folder is empty.

after installing the package - which is easy on a linux distrib : apt-get install ...-
i'm supposed to apply the dblink.sql file on the database i'd like to use dblink_connect() in.

question:
is it normal to find the file dblink--1.0.sql in
C:\Program Files\PostgreSQL\9.2\share\extension ?

i'm confused,
can someone help me to figure this out ?

is it normal not to have extensions in contrib ? is the file dblink--1.0.sql the package ?
......
i badly need an explanation ;)

thank you in advance for all your help.
0
Comment
Question by:toshi_
  • 4
  • 2
6 Comments
 
LVL 22

Expert Comment

by:earth man2
ID: 38711175
My dblink.sql is in C:\Program Files\PostgreSQL\9.0\share\contrib
0
 
LVL 22

Expert Comment

by:earth man2
ID: 38711588
http://www.postgresql.org/docs/9.2/static/dblink.html
it interfaces directly with library dblink.dll
0
 
LVL 22

Expert Comment

by:earth man2
ID: 38714652
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:toshi_
ID: 38723125
hello earthman,
...i feel like a small boy when you gave me links like the last you gave me...
i'm  not able to read the c code for dblink you gave me... .i dont really know where to start with in order to have an answer to my question.

i dont know how to deal with the help on this thread, makes me thing you honour me as if i was an expert of your level ;)

so far i understand that my windows postgrres install - i did not change a single thing from the default install - is not the same than yours. Did you change when installing ?

what should i understant with the link to dblink.sql ?

toshi
0
 
LVL 22

Accepted Solution

by:
earth man2 earned 300 total points
ID: 38725745
If your distribution has a script dblink.sql and library dblink.dll then running the script dblink.sql using psql.exe or PgAdmin should install the required stored functions.
0
 

Author Closing Comment

by:toshi_
ID: 38774195
ritght on,

my script was in share/extension,
after importing the file with psql i can see a new Extension - with Pgadmin - in my db. So far i had only plpgsql, now i have both: plpgsql and dblink.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question