[Lazarus] PosgeSQL client

[Andrew Brunner]

On Mon, Dec 22, 2008 at 10:09 AM, Eric March <sales at ebmpl.com.au> wrote:
> I have SQLdb component installed in Lazarus 0.9.24 beta x86_64-linux-gtk
> on Ubuntu 64 bit linux.
> I tried running mysql but get an error which needs FPC 2.2.3 or later.
> I can only find RPM files
> for that source and I can't install it.  I can download FPC.zip and
> compile that source but it
> turns out to be still FPC 2.2.2, which is what I was running.

You're FPC installs are messed up.  You need to link the FPC compiler
in the /usr/local to the new version.  Use Nautilus to browse your
paths and check these links.  I'd bet your FPC is pointing to the
older version.

You can get the latest form SVN locally and follow the installation
instructions on the Wiki to build, install, install source.   But when
you do the ln (symbolic links) do them under SUDO.


>
> I think PostgreSQL database system has better record locking and other
> functions that make
> it superior to MYSQL, so rather than spend time on finding an FPC source
> 2.2.3 or later that
> I can make compile I thought I would try Postgress.
>

I hear that Postgres was more difficult to manage though.


> I opened a new project and placed a PQConnection on Form1, set host name
> as localhost,
> username as postgres with no password.  When I set Connected to "TRUE" I
> get the
> following error.
>
> Can not load PosgreSQL client. Is it installed? (libpq.so)
>
>
>
> How do I install PostgreSQL client?
>

I would always try to use the Package Manager.