I was able to install Apache, PHP and postgres. They all work on thier own, Apache and PHP even work together but I can't seem to get postgres working with PHP/ When I compiled PHP I used "--with-pgsql=/user/local/pgsql/bin"
Is this correct.?.?

This is what I get when I try to run a program with postgres from the command prompt (this program works on another server):

PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php/extensions/mysql.so' - libmysqlclient.so.14: cannot open shared object file: No such file or directory in Unknown on line 0


Why is it looking for mysql when I compiled it with postgres.?

How can I get this working correctly.?

I figured out how to get around this problem. The php.ini file needed to have the mysql links fixed.

Now...

Apache and seem to work togehter fine. When I try using postgres in php using Apache I get:
Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host localhost and accepting TCP/IP connections on port 5432? in /home/sites
--- and ---
Warning: pg_last_error() [function.pg-last-error]: No PostgreSQL link opened yet in /home/sites/spfx/site_list.html on line 22

How do I know if "localhost" and "TCP/IP connections" are setup correctly and how do I know the server is running on port "5432".?

I know the postgres server is running, I can access the database using "psql".

If I run the php/postgres program from the command prompt it stops as soon as is hits the first "pg_" command. No output, no errors, it just stops.

More info...

For years on all my servers and all my sites I have used:
$conn = pg_Connect("localhost", "5432", "", "", "$database");

Now that this is the first server I completely loaded it sudden;t doesn't work but if I make a minor change it works:
$conn = pg_Connect("localhost", "5432", "nobody", "", "$database");

This should be sinple but my question is do I need to changes "ALL" my programs that use "pg_Connect" or is there something I so I don't have to change all my programs.

this isn't the where I should be asking this questions but what is the correct usage:
$conn = pg_Connect("localhost", "5432", "", "", "$database");
--- or ---
$conn = pg_Connect("localhost", "5432", "nobody", "", "$database");