Re: Dblink question

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