Re: Dblink question - Mailing list pgsql-general

From Joe Conway
Subject Re: Dblink question
Date
Msg-id 40ACD8CE.1020003@joeconway.com
Whole thread Raw
In response to Dblink question  ("Sam Masiello" <smasiello@mxlogic.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with sorting using 'ORDER BY' when character field is filled with numerical values
Next
From: Tom Lane
Date:
Subject: Re: backend terminated abnormally