PostgreSQL connection functions typically need some info from your script in order to run properly. You are using what appears to be the "old" PHP syntax.
The new syntax looks like the following, note not all parameters are required
and see what happens.
$conn = pg_connect("host=myHost port=myPort tty=myTTY options=myOptions dbname=myDB user=myUser password=myPassword ");
// Change your script to include at least:
host=yourhostname // could be local host
i.e. try at least:
$conn = pg_connect("host=myHost dbname=myDB");
and if that doesn't work, be sure you have CREATE USER someuser and GRANT user to ....
You should also configure specific users and passwords to have access to specific databases. You don't want to give "nobody" access to every table / database in the joint.
PostgreSQL docs on user management are straightforward - refer to them now.
This is pretty basic stuff -- chances are very high you will end up leaving security holes in your wake as you pass through this. Be careful, or better yet, get some experienced help to get you going on the right path.
Last edited by mwatkins; 10-28-2002 at 05:27 PM.
“Even those who arrange and design shrubberies are under
considerable economic stress at this period in history.”