Dblink question
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
"Sam Masiello" <smasiello@mxlogic.com> writes:
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
Did you compile the dblink shared library and install it in the correct
place?
regards, tom lane
I ran "make" and "make install" which is what I thought the readme said
to do. Did I miss something obvious?
--Sam
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, May 19, 2004 1:19 PM
To: Sam Masiello
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dblink question
"Sam Masiello" <smasiello@mxlogic.com> writes:
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
Did you compile the dblink shared library and install it in the correct
place?
regards, tom lane
Import Notes
Resolved by subject fallback
Please disregard this thread going forward. I figured it out and feel
all the more stupid for it :)
--Sam
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Sam Masiello
Sent: Wednesday, May 19, 2004 1:29 PM
To: Tom Lane
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dblink question
I ran "make" and "make install" which is what I thought the readme said
to do. Did I miss something obvious?
--Sam
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, May 19, 2004 1:19 PM
To: Sam Masiello
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dblink question
"Sam Masiello" <smasiello@mxlogic.com> writes:
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
Did you compile the dblink shared library and install it in the correct
place?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match
Import Notes
Resolved by subject fallback
Sam Masiello wrote:
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
This is not a dblink error per se, but rather a "dynamic library can't
be found" error. At a shell prompt, run the following:
pg_config --pkglibdir
That should output the $libdir path (e.g. /usr/local/pgsql/lib). Now go
look there for dblink.<dll-ext-for-yourOS> (e.g. dblink.so). If it isn't
there, do a "make clean" and show us the output of
make
make install
make installcheck
Joe