Can not load PostgreSQL Client libpq.so

[99Percent]

I can run my Lazarus program fine in my development machine, but when I move my executable to another computer I get:

Can not load PostgreSQL client. Is it Installed? (libpq.so)

I have tried almost everything I can think of to get it working to no avail incluiding a copying the libpq.so file on the same directory, recreating the library directory structure the same as in my development computer (it is /usr/local/pgsql/lib vs /opt/PostgreSQL/9.1/lib), adding symlinks all over, adding the library path to the PATH environment variable.

pgadmin3 works fine on the target computer, so I am at my wits end. Please help.

[marcov]

So, where is your libpq.so ?  Is your library in the LD_LIBRARY_PATH environment or listed in /etc/ld.so.conf?

[goodname]

Lazarus Postgre component depends on libpq. libpq depends on other libraries. Have not looked into the the required libraries for libpq 9.1 yet. If you figure them out I would be interested to know what they are.

If pgAdmin works then that suggests all the required libs are already installed somewhere.

[99Percent]

So, where is your libpq.so ?  Is your library in the LD_LIBRARY_PATH environment or listed in /etc/ld.so.conf?

echo $LD_LIBRARY_PATH returns nothing
my libpq.so is anywhere I want it, with the same result
if I add text file indicating the directory of the library files for /etc/ld.so.d is useless

[99Percent]

debian x64

[cpalx]

install libpq-dev

[99Percent]

install libpq-dev

it will install 8.4 no matter?

[99Percent]

I installed libpq-dev anyway and that did the trick. I would like to know what the hell it fixed though, because obviously this is not the right way.

[Silvio Clécio]

Hi,

Is SQLdb compatible with PG 64 on 64 platform?

Thx.

[99Percent]

Hi,

Is SQLdb compatible with PG 64 on 64 platform?

Thx.

yes, it works fine

[Silvio Clécio]

Really?  thank you guy.

After this news, I'll retire the Zeos.

Thanks again.

[99Percent]

That is good, I never liked Zeos, its just too big.

Hopefully soon someone will make a direct TPQConnection that doesn't require libpq.so or libpq.dll

[jixian.yang]

Maybe there should be a light database package.

[BigChimp]

I installed libpq-dev anyway and that did the trick. I would like to know what the hell it fixed though, because obviously this is not the right way.

Actually, I think that's the proper way: use your distribution's package manager to install the database client library package.

If you distribute your application in a .deb or. rpm, you can specify this package as a dependency...

[cpalx]

when you install libpq, you have the library: /usr/lib/libpq.so-XX, and lazarus needs libpq.so, so you have to alternatives
1. make the simbolik link
2. Install libpq-dev to isntall the source and it makes the simbolik link