How to install the database server

1. Installation of the PostgreSQL database

Download the PostgreSQL database software (version 8.4 or later) from http://www.postgresql.org/download/ and copy the installer file(s) to your database server. Start the installer and follow the installation wizard using the default settings until following pages:
ATTENTION: When using PostgreSQL >9 you may need to install it to ‘C:\PorstgreSQL\’ instead of ‘C:\Program Files\PostgreSQL\’ as it may fail to initialize the database otherwise.
clip_image002

  • Enter the password for the database super user (this will be the main user for the whole database).
    Please note: In case your server has a user password complexity policy enforced (enabled by default on Windows® Server), the password you enter must meet these requirements.

Click “Next” and use the default values again until:

clip_image002[6]

Confirm the success of the installation, but uncheck the checkbox "Launch Stack Builder at exit" before finishing.

2. Configuration of the PostgreSQL database

Start pgAdmin III which allows you to configure the PostgreSQL database:

clip_image002[8]

Now click on "File" => "Open pg_hba.conf…" and open the configuration file from:
C:\Program Files\PostgreSQL\8.4\data\pg_hba.conf
(This directory depends on your installation path and PostgreSQL version). The following dialog will appear:

clip_image002[10]

First, double-click the second row and check "Enabled" to allow IPv6 loopback connectivity:

NOTE: Newer Versions of PostgreSQL may already have this enabled.

clip_image002[12]

Click "OK" to close the dialog.

Double-click the third (empty) row to create a new entry and change the values to the following:

clip_image002[14]

Direct database access mode: Enter "0.0.0.0/0" to accept connections from all computers.

MemoryLifter web service mode: Only enter the IP address of your server and if necessary, the IP addresses of the users who need admin access (via Admin Suite).

Don't forget to save the settings before closing the dialog.

3. Create a new database user

The following point is just an additional nice to have feature. To avoid using the super user account, you can create a new account with restricted rights (e.g. only read/write access to the MemoryLifter database). If you do not want to create a special database user for the MemoryLifter Server, skip to "Initialize the MemoryLifter Database" (Section 3.4) and use the default database user.

First of all connect to your database:

Right click on "PostgreSQL x.x ..." and then click on "Connect".

clip_image002[16]

Enter your super user password into the following dialog and click "OK".

Now you can create a new database user:

clip_image002[18]

Right click on "Login Roles (1)" then click on "New Login Role…" to create a new database user.

clip_image002[20]

Add the values like above into the dialog (use a new password for the 'mlifterUser' account).

Now switch to the tab "Role privileges" and add the values like above into the dialog:

clip_image002[22]

Click "OK".

A new database user has been created. Now click on your PostgreSQL server in the tree view and disconnect from the server:

clip_image002[24]

Now right click on the PostgreSQL server and click on Properties.

clip_image002[26]

The properties dialog appears:

clip_image002[28]

Change the username (case sensitive) to the newly created user and press OK.
Attention:
From now on you will login as "mlifterUser" when you double click on the "PostgreSQL Database Server" node. If you want to do some major changes, which require the super user account, repeat the last three steps and use the "postgres" user instead of "mlifterUser".

4. Initialize the MemoryLifter database

To initialize the database select "PostgreSQL Database Server" from the tree view, enter your super user password and select the node "Databases (1)". If you created a special database user account, please disconnect from the PostgreSQL database server and reconnect with your special database user account (how to: see above section).

Right click on "Databases (1)", than click on "New Database..." to create a new database:

clip_image002[30]

image

Set the values shown above in the dialog and click "OK". Do not forget to select UTF8 for the encoding!

Now select the "memorylifter" database and click on the "Execute SQL query" button (see image). A new dialog appears:

image

Click on "File", "Open" and select the "MemoryLifterServerDatabaseScript.sql" file from your MemoryLifter Server package (ATTENTION: the current version has a minor bug in the SQL script you need to fix manually - please see HERE):

clip_image002[32]

Now click on the execute button (green “play”-button). After a few seconds, you will see the result of the query in the output pane:

clip_image002[34]

The database initialization has been successfully completed when the last output line reads "Query returned successfully with no result in … ms". If this is not the case, copy the output message and contact us at support@memorylifter.com.

Now the PostgreSQL database system and the MemoryLifter database are fully installed and configured. For directions on how to use the MemoryLifter Server, continue reading this documentation.

5. Help

For more help regarding the configuration and installation of a PostgreSQL database system or MemoryLifter database, have a look at http://www.postgresql.org/docs/ or contact us directly at support@memorylifter.com.

Last edited Jan 24 at 5:43 PM by CFI, version 4

Comments

No comments yet.