Skip site navigation (1) Skip section navigation (2)

Re: Dblink question

From: Joe Conway <mail(at)joeconway(dot)com>
To: Sam Masiello <smasiello(at)mxlogic(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dblink question
Date: 2004-05-20 16:11:58
Message-ID: 40ACD8CE.1020003@joeconway.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-05-20 16:13:28
Subject: Re: backend terminated abnormally
Previous:From: Tom LaneDate: 2004-05-20 16:10:38
Subject: Re: problem with sorting using 'ORDER BY' when character field is filled with numerical values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group