Using Apache/PHP with Postgres Plus® Standard Server v8.3 Tutorial for Mac

Related Resources

Learn how to quickly get around the Postgres Plus Apache/PHP stack in a Mac OS X environment.

Find the httpd.conf that was part of your Apache web server installation and open httpd.conf with your favorite editor. Once open you will see something similar to this:


#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the 
# directive.
#
# Change this to Listen on specific IP addresses as shown below to 
# prevent Apache from glomming onto all bound IP addresses (0.0.0.0)
#
# Listen 12.34.56.78:80

Listen 8888

This will show you that Apache is listening on port 8888. You may set this to your port number of your choice.

After installing Postgres Plus, find the postgresql.conf file and open it using your favorite editor. You will find in the postgresql.conf file a section that looks like this:

#listen_addresses = 'localhost'  # what IP address(es) to listen on; 
                    # comma-separated list of addresses;
                    # defaults to 'localhost', '*' = all
                    # (change requires restart)
port = 9432             # (change requires restart)

In the case above, Postgres Plus is listening on port 9432.

Using the start database and stop database scripts on OS X you are able to verify that the database has been installed. In addition the tutorial on PHP and Apache shows you how to confirm the installation and setup of both PHP and Apache.

In order to install the Postgres Plus phpPgAdmin Bundle, first download the Postgres Plus phpPgAdmin bundle from www.enterprisedb.com for OS X.

Once you have downloaded the program, initiate the installation by clicking on the .dmg file. This will initiate the installer as shown below.

You are now ready to set your port for your phpPgAdmin server.

The installation is now complete. To confirm your installation, simply run the phpPgAdmin application.