Hello all,
After getting crazy about the fact that MySQL does not support
subqueries, i decided to give it a go with PostgreSQL. Compiling and
installing went fine, but i'm having trouble understanding the database
user and security concepts that PostgreSQL uses.
Can any of you tell me how i configure PostgreSQL for access by PHP? I
have PHP compiled as a Apache module (with pgsql support ofcourse), and
Apache runs under nobody:nogroup. What needs to be done to be able to
use pgsql via PHP with regards to what users need to be added, what
files need editing and how to make the whole thing secure?
Also i'm having trouble using postgresadmin from www.phpwizard.net. It
displays the following error:
--
Warning: Unable to connect to PostgresSQL server: FATAL 1: Database
dbname=template1 does not exist in pg_database in lib.inc.php3 on line
125
--
Although the database template1 does exist when loging in as the
postgres superuser and executing 'psql template1'. Am i doing anything
wrong here??
Any help would be greatly appreciated.
Thanks in advance,
Hans Rakers
--
---------------------------------------------------------------------
Hans Rakers (hans@clubned.com) Tel: +31 (0)20-4490485
System engineer / Webmaster / Webdeveloper Fax: +31 (0)20-4490495
ClubNed - TeKoop http://www.clubned.com
Badhoevedorp, the Netherlands http://www.tekoop.nl