Postgres Plus 8.3 Linux Installation

Postgres Plus is the world's most advanced open source database.

This tutorial will lead you through the installation of Postgres Plus on Linux.

EnterpriseDB is the world's leading commercial Postgres company. EnterpriseDB has developed installers that simplify the Postgres Plus installation process. These installers are available at www.enterprisedb.com.

The EnterpriseDB Community Center is a community-based site for enterprise application developers and DBAs. As well as downloads, it contains tools, technical information and community based forums. The installation process we will be going through today is straightforward, however if you experience any difficulties, have questions or suggestions concerning your Postgres experience, the Resource Center is designed specifically to help you.

The Postgres Plus installer can be downloaded by clicking here.

You will be asked if you want to save the download for installation later, or whether you want to open the archive and start the installation process right away.

The installer is compressed for quicker downloads, so once the download is complete, you’ll need to use your compression/uncompression tool of choice to uncompress the file

go to the download location and extract the installer

postgres@edb:~> cd downloads
postgres@edb:~/downloads> tar -zxvf pgplus-831-1-linux-x32.tar.gz
pgplus-831-1-linux-x32/
pgplus-831-1-linux-x32/postgresplus_x86-32.bin
postgres@edb:~/downloads>

Go to the directory you just created, change to superuser, and then execute the setup file

postgres@edb:~/downloads> cd pgplus-831-1-linux-x32
postgres@edb:~/downloads/pgplus-831-1-linux-x32> su
Password:
postgres:/home/postgres/pgplus-831-1-linux-x32 # ./postgresplus_x86-32.bin
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE..
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

When the installation begins, you will see the introduction panel below

When you press NEXT, you will be presented with a list of Install components

On the Installation Options panel, you will see that you can install two components, the Database Server, and Developer/Client Tools.

Postgres Plus is an open source project, and along with the database, there are a number of other useful projects and tools available. EnterpriseDB has bundled the most commonly used features into the Installer. Along with the database itself, we install the SLONY-I Replication System that provides asynchronous master/slave replication, Distributed Memory Caching using memcached and pgmemcache, Connection Pooling using PgBouncer, and PosttGIS geospatial extensions.

In Developer/Client tools, we install pgAdmin III - a graphical database development and management tool, a MySQL migration toolset, plus PSQL Terminal - a powerful command line client. Additionally we install the libpq, ODBC and JDBC connectors and embedded C.

GridSQL is a powerful parallel query engine for OLAP type applications.

This is a full function set of tools and facilities that get installed so that you can get productive as soon as the install finishes. If you find that you need any of the other components that can be used with Postgres Plus, the EnterpriseDB Community Center has many of them available as downloads, and has forums to help you with this process.

EnterpriseDB has included several value added features into Postgres Plus. The first is installation tuning that optimizes the database based on your server configuration. The second is a notification service that helps you keep your installation up to date. We need to be able to get in contact with you to do this. If you are not already a user, you can create an account. If you are a returning user, enter your email address and password.

When you select installation tuning, your database will be optimized based on how the server that the database will be installed on is being used, and the projected workload for the database.

Press NEXT on this screen, and you will be prompted for an install directory. You can choose where Postgres Plus will be installed.

When you are ready press NEXT

Postgres Plus requires a LINUX user that will own the database server - it must not be root, and the user does need to exist

Go ahead and enter a userid

When you press NEXT, you will see an option to seperate out the database data and Transaction Logs. We recommend that you do this for performance reasons. Don't worry, the database server keeps track of these things.

Next, you will be asked for the port that Postgres Plus will run on. The default port is 5432. You can override this if you wish.

you can also ask that Postgres Plus will be started and ready to use each time you start your machine

Finally, you need to specify a database super user. This is a database user (not an operating system user) and it is used for database administration (like adding new users)

Once you have done this, you will be presented with a pre-install summary where you can see the options you have selected. If you wish to change any of these you simply press Previous. Pressing Install begins the installation process.

When you press Install, you'll see the following progress panel

Once the installation is complete, you will see the following panel - you are now ready to start using your database!

To start using your database, use the Postgres Plus menu pick that was created in the install process.

You’ll see the following options for the Database Server:

You'll see the following options for Developer & Client Tools: