PostgreSQL is an open source relational database that can be run in different platforms. It is also compatible with various programming languages. The following guides will show you how to install the program.
How to Install PostgreSQL
Step 1
Get the PostgreSQL source code package from the Internet. Unzip it using these commands: gunzip postgresql-8.3.1.tar.gz & tar xf postgresql-8.3.1.tar.
Step 2
Move the postgresql-8.3.1 folder under the present folder where the source code had been unpacked.
Step 3
Keep running the configure script to set up the source tree for your system. The default setup assesses the components in the system. It will conduct examinations to determine what values will be utilized to make the source tree. This is going to build the tools, server
and client applications.
Step 4
Enter “gmake install” to put the files in the folders you made. The installation is finished.
Tips
The build can go about in various ways depending on the preferences you set on the command line. It is also possible to make changes following the package installation.
It is also possible to start all over again. Rebuilding the installation is possible. It means you can change the system settings until the right configuration is attained.
How to Install PostgreSQL PHP Connectors in Windows XP
Step 1
Find the php.ini file. In some PHP installations, this is in the C:\Windows folder. If it isn’t there, go to the folder where you installed the PHP files. Use Notepad or another simple text editor to open this file.
Step 2
Scroll through the file until you see the “;extension=php_pgsql.dll” line. Change it to take away the semicolon. It should now read “extension=php_pgsql.dll”. Click file, save.
Step 3
Restart the web server. Reload the PHP. Go to the Start menu and choose “Run”. Type “iisreset” as the administrator.
Tips
You can verify the php_pgsql.dll module is loaded by making another PHP file. At the web server, use the following syntax: “<?php phpinfo(); ?>”. After running the file, it will be visible at the modules.
Warnings
Make sure you study the configuration before making changes. While the program is easy to use, making unnecessary changes may lead to unforeseen problems.It is better to be sure, so examine the configuration.