BitNami PostgreSQL Module 5.4.15-0 =================================== 1. OVERVIEW The BitNami Project was created to help spread the adoption of freely available, high quality, open source web applications. BitNami aims to make it easier than ever to discover, download and install Open Source software such as document and content management systems, wikis and blogging software. You can learn more about BitNami at http://bitnami.com PostgreSQL Module is a add-on for WAMPStack, LAMPStack, MAMPStack or RubyStack. This module ships and configure PostgreSQL database server and phpPgAdmin application to handle the administration of PostgreSQL over the Web. You can learn more about BitNami Stacks at http://bitnami.com/learn_more/ 2. FEATURES - Easy to Install BitNami Stacks are built with one goal in mind: to make it as easy as possible to install open source software. Our installers completely automate the process of installing and configuring all of the software included in each Stack, so you can have everything up and running in just a few clicks. - Independent BitNami Stacks are completely self-contained, and therefore do not interfere with any software already installed on your system. For example, you can upgrade your system's MySQL or Apache Tomcat without fear of 'breaking' your BitNami Stack. - Integrated By the time you click the 'finish' button on the installer, the whole stack will be integrated, configured and ready to go. - Relocatable BitNami Stacks can be installed in any directory. This allows you to have multiple instances. 3. COMPONENTS BitNami PostgreSQL Module ships with the following software versions: - PostgreSQL 9.2.4 - PHPPgAdmin 5.1 4. REQUIREMENTS To install BitNami PostgreSQL Module you will need: - Intel x86 or compatible processor - Minimum of 256 MB RAM - Minimum of 150 MB hard drive space - An x86 Linux operating system - TCP/IP protocol support 5. INSTALLATION The BitNami PostgreSQL Module is distributed as a binary executable installer. It can be downloaded from: http://bitnami.com/stack/ The downloaded file will be named something similar to: bitnami-postgresql-5.4.15-0-module-linux-installer.run on Linux You can install BitNami PostgreSQL Module in graphical, text and unattended modes. By default the graphical mode will be used. On Linux, you will need to give it executable permissions: chmod 755 bitnami-postgresql-5.4.15-0-module-linux-installer.run You will be greeted by the 'Welcome' screen. Pressing 'Next' will take you to the 'License Agreement' page. You must accept the agreement to continue the installation. The next step is to select the directry where WAMPStack, LAMPStack, MAMPStack, SAMPStack or RubyStack installation is located. It may be required to run the module installer as root if that previous installation was run with admin privileges. After selecting the installation directory you will be asked for the existing MySQL password - the one used while installing WAMPStack, LAMPStack.. This password will be used to initialize PostgreSQL root and postgres accounts. The default listening port for PostgreSQL is 5432. If that port is already in use by other applications, you will be prompted for alternate port to use. Remember that if you plan to run postgres as a regular user you should select a port number above 1024. You are now ready to begin the installation, which will start when you press 'Next'. Once the installation process has been completed, you will see the 'Installation Finished' page. If you receive an error message during installation, please refer to the Troubleshooting section. The rest of this guide assumes that you installed BitNami PosgreSQL Module over a LAMPStack located in: /home/user/lampstack-5.4.15-0 and that you use port 8080 for Apache and 5432 for PostgreSQL. 6. STARTING AND STOPPING BITNAMI POSTGRESQL In order to start/stop/restart postgresql service, a new entry is added to the previously installed stack 'ctlscript': ./ctlscript.sh (start|stop|restart) ./ctlscript.sh (start|stop|restart) mysql ./ctlscript.sh (start|stop|restart) postgresql ./ctlscript.sh (start|stop|restart) apache start - start the service(s) stop - stop the service(s) restart - restart or start the service(s) To access phpPgAdmin. You can point your browser to http://127.0.0.1:8080/phppgadmin/ For security reasons it is only accessible when using 127.0.0.1 as the hostname. If you selected an alternate port during LAMPStack installation, for example 18080, the URL will look like: http://127.0.0.1:18080/phppgadmin/ 7. DIRECTORY STRUCTURE The installation process will create several subfolders under the main installation directory: postgresql/: PostgreSQL Database. apps/ phppgadmin/: Management tool for PostgreSQL. 8. TROUBLESHOOTING This version of the BitNami PosgreSQL Module is a preview version, and as such, may contain a number of bugs and be a little bit rough around the edges. We are working on the next release, which will contain several improvements along with expanded documentation. In addition to the resources provided below, we encourage you to post your questions and suggestions at: http://answers.bitnami.com/ We also encourage you to sign up for our newsletter, which we'll use to announce new releases and new stacks. To do so, just register at: http://bitnami.com/newsletter. 8.1 Installer # Installer Payload Error If you get the following error while trying to run the installer from the command line: "Installer payload initialization failed. This is likely due to an incomplete or corrupt downloaded file" The installer binary is not complete, likely because the file was not downloaded correctly. You will need to download the file and repeat the installation process. # Installer execution error on Linux If you get the following error while trying to run the installer: "Cannot open bitnami-postgresql-5.4.15-0-module-linux-installer.run: No application suitable for automatic installation is available for handling this kind of file." In some operatings systems you can change permissions with right click properties -> permissions -> execution enable. Or from the command line: $ chmod 755 bitnami-postgresql-5.4.15-0-module-linux-installer.run 8.2 PostgreSQL If you encounter any problems starting PostgreSQL, the first place to look in is PostgreSQL documentation, which you will find at http://www.postgresql.org/docs/ # "Can't connect to server" message. Make sure that the PostgreSQL daemon is up and running. Remember also that if during installation you selected a different listening port for PostgreSQL, you may need to pass that as an extra command line option. 8.3 phpPgAdmin To test your phpPgAdmin installation first make sure that your Apache and PostgreSQL servers are up and running. You can access your phpPgAdmin installation by opening a browser and typing http://127.0.0.1:8080/phppgadmin. The phpMyAdmin administrative user is 'postgres' and as password use the value specified during installation. 9. LICENSES PostgreSQL is distributed under the BSD License, which is located at http://www.freebsd.org/copyright/license.html phpPgAdmin is distributed under the GNU General Public License v2, which is located at http://www.gnu.org/licenses/old-licenses/gpl-2.0.html Freetype is released under The Freetype Project License, that is located at http://freetype.sourceforge.net/FTL.TXT