X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A43C3D1B4EF; Sun, 9 Nov 2003 15:34:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00602-02; Sun, 9 Nov 2003 11:34:07 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 90A37D1B4E6; Sun, 9 Nov 2003 11:34:03 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hA9FY719003364; Sun, 9 Nov 2003 10:34:07 -0500 (EST) To: radha.manohar@ndsu.nodak.edu Cc: pgsql-novice@postgresql.org, pgsql-performance@postgresql.org Subject: Re: error while executing a c program with embedded sql In-reply-to: <3324.134.129.110.96.1068390374.squirrel@webmail.ndsu.nodak.edu> References: <3324.134.129.110.96.1068390374.squirrel@webmail.ndsu.nodak.edu> Comments: In-reply-to message dated "Sun, 09 Nov 2003 09:06:14 -0600" Date: Sun, 09 Nov 2003 10:34:06 -0500 Message-ID: <3363.1068392046@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/61 X-Sequence-Number: 8764 writes: > ./test1: error while loading shared libraries: libecpg.so.3: cannot open > shared object file: No such file or directory The dynamic linker is failing to find either libecpg.so itself, or one of the shared libraries it depends on (perhaps libpq.so). If you are on a Linux system you probably want to fix your ldconfig configuration so that all these libraries are found automatically. You can run ldd on a particular executable or shared library to see what libraries it references and whether those libraries are getting found in the proper places. Note that it is entirely possible for the program linking stage to succeed but dynamic linking to fail at runtime. For various reasons the search rules are not quite the same in the two contexts ... regards, tom lane