MJRay wrote:

...

psql points to /usr/bin/psql which is a link to pg_wrapper, which is a binary file, which presumably has the full path. How would I alter

this?

Recompile with the right prefix, probably.

I think I'll try and cheat and see if i can just create /usr/lib/postgresql/bin/psql as a link to /usr/local/pgsql/bin/psql. I daren't recompile - I just got php, postgres, apache working together after trying for a month. I danced singing round the office this morning.

....(There are debian packages for postgres, btw.)

I originally installed it from the deb package but I couldn't get php to compile with psql, as libpq-fe.h was missing. My bro' told me: "lipq-fe.h is a C header file which should be in the lib directory of Postgres BUT may not be there unless you built Postgres from source.

A header file is a sort of contract that C makes, declaring which functions there will be, and they're used for linking programs together, eg php and postgres."

Thanks, Jenny.