Jump to content

Postgres Plus 8.3 Windows Installation

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

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

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 Plus experience, the Community Center is designed specifically to help you.

The Postgres Plus installer can be downloaded by clicking here.

Some browsers will require you to click on the Information Bar to start the download.

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

Once you have extracted the installer, browse to the folder you extracted to and double click on the msi file to start the installation process (do not try to execute the installer from inside the archive or you'll see an error saying that the installer is not verified).

 

 

When the installation begins, you can select the language to be used during the installation process, we will be using English

 

 

Press NEXT on the panel below

 

 

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

Postgres 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 Postgres Plus, we install the SLONY-I Replication System that provides asynchronous master/slave replication, and PostGIS geospatial extensions. In Developer/Client tools we install pgAdmin III, a graphical database development and management tool. We install psql, a powerful command line client. Additionally we install the .NET provider, ODBC and JDBC connectors and embedded C. We also provide a MySQL to Postgres Plus migration tool.

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.

 

 

In the panels above, we've outlined what each of these options give you. Go ahead and click NEXT

The next panel allows you to create an account that will run the Postgres Plus service. You will be able to start and stop Postgres Plus from the Start Menu from the account that you are installing from.

The account that is created in the step below is set up and configured properly to allow you to start and stop the windows services that Postgres Plus will use.

 

 

If you see this panel, go ahead and grant 'Log on as a service' rights to this account. It allows you to log on and start and stop the service.

 

 

This panel (if you see it) simply allows you to log on locally (i.e. on the machine you are installing Postgres Plus on), Go ahead and grant this right.

 

 

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.

 

 

The installer is now ready to start creating the database (initdb), when you see this panel.

 

 

When the Initialize database cluster checkbox is selected, the other options on this panel become active, from top to bottom they are:

 

Option Description
Port number This is the port that the Postgres process listens on. The default Postgres port is 5432. You can override this if you wish.
Addresses This allows other computers to connect to your database
Locale This sets the language that your database will use for things like system messages
Encoding This sets how characters are stored in binary on the disk
Superuser As described on the panel, this is NOT the Windows service account that you created previously, this is the database superuser. Once you have created the database, you need to be able to administer it (add users, create tables etc.) and this is the database account that is set up to do that.

That's it, you'll see a panel that says you are now ready to install the database, click NEXT and the installation process will run to completion.

When you see the panel below, click FINISH and you're all set to start using your database!

 

 

To start using your database, click on START Then ALL PROGRAMS

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

 

 

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

 

 

To see the Windows service for Postgres, click on START Then RUN Then type SERVICES.MSC (see below)

 

 

And you will see the Windows Service for Postgres Plus, SLONY-I (Replication) and the Postgres Plus Scheduler