Dblink question - Mailing list pgsql-general

From Sam Masiello
Subject Dblink question
Date
Msg-id ECAB83AA52BCC043A0E24BBC000010240F52@mxhq-exch.corp.mxlogic.com
Whole thread Raw
Responses Re: Dblink question  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Dblink question  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Hello all!

I am rather stuck and am hoping someone can help. I am working on a
project where users need to be able to send one query which will hit
databases on multiple hosts (the database structures are the same) and
tie the data back together again.

After doing lots of reading it looks like dblink might be a great
solution for this. After trying to insert dblink.sql into the database,
I just get a series of errors:

ERROR: stat failed on file '$libdir/dblink': No such file or directory

Does anyone know how I can get around this error? Or is dblink not
really a good solution for what I am trying to do? I am sure others out
there have had to do similar tasks before so any advice that can be
provided would be greatly appreciated!

TIA for your time and reply!

--Sam

pgsql-general by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: Function - sequence - cast
Next
From: Christopher Browne
Date:
Subject: Re: Does INSERT inserts always at the end ?