David Lee Lambert dlambert at bmtcarhaul.com
Tue Aug 26 14:25:39 PDT 2008
On Tuesday 26 August 2008 11:12:31 am Víctor wrote:
> Watching the following error in the output of make:
>
> slon.c:33:22: error: libpq-fe.h: No such file or directory
>
>
> You should install packages libpq-dev and postgresql-server-dev in your
> ubuntu workstation. If the same error occurs in your Gentoo box you should
> emerge dev-db/libpq.

OK,  libpq-dev was already installed (version 8.3.3-0ubuntu0.8.04).  I 
installed postgresql-server-dev-8.2 (version 8.2.7-1; no -8.0 was available),  
and re-ran 'configure' as such:

./configure --with-pgbindir=/usr/lib/postgresql/8.0/bin/ --with-pgincludedir=/usr/include/postgresql --with-pgincludeserverdir=/usr/src/postgresql-8.0-8.0.7/build-tree/postgresql-8.0.7/src/include/ --with-pgpkglibdir=/usr/lib/postgresql/8.0/lib/

I ran 'make' and copied the .so files into the Postgres 8.0 "lib" directory,  
and tried to invoke "slonik" again.  I still get an error similar to what I 
saw before:

$ slonik <try1.slonik
<stdin>:7: PGRES_FATAL_ERROR 
select "_davidswaybill".initializeLocalNode(1, 'koios'); 
select "_davidswaybill".enableNode(1);  - ERROR:  function setval("unknown", 
bigint) does not exist
HINT:  No function matches the given name and argument types. You may need to 
add explicit type casts.
CONTEXT:  SQL statement "SELECT  setval('"_davidswaybill".sl_rowid_seq',  
$1 ::int8 * '1000000000000000'::int8)"
PL/pgSQL function "initializelocalnode" line 26 at perform
<stdin>:7: ERROR: no admin conninfo for node 134598976




-- 
David L. Lambert
  Software Developer,  Precision Motor Transport Group, LLC
  Work phone 517-349-3011 x215
  Cell phone 586-873-8813


More information about the Slony1-general mailing list