HyperLeda: Installation with a provided database server

By default Pleinpot will install the Postgres software (Database Management System), if the right version of the library or programs are not found on your platform (presently Postgres 7.4.2), and it will initialize a new database cluster, start the server (postmaster program), create a database and user, and load the data.

If a Postgres server is yet running on your machine, it would be an advantage to reuse it (reduce the load on the machine). If you still prefer to have a separate new server (this is the simplest) you may still have to instruct Pleinpot to use a free port for the connections with the server, because the default Postgres port may be yet used by the existing server.
Possibly you can also wish to use the HyperLeda database installed in another Pleinpot installation, on the local host or through IP connection (for example to save disk space)... In these cases you must read the following.

There are three levels to consider in what is installed in the current installation:

  1. The postgres software (libraries, client and database backend).
  2. The database server process (postmaster) and the database storage area.
  3. The data stored in the database.

Software installation

Even if you do not install locally the database, the software is required to allow remote IP connections.
The default installation will automatically check if the software is present and decide to install it if it is not found, or if it has not the correct version number (presently 7.4.x). Use the configure program to see what Pleinpot see on your platform (please read the main instructions page to learn about the configure options and environment variables you have to set). You may type:
          cd ${PL_ROOT}
The output of this program is not very easy to read if you are not used to this kind of procedures, here is what you should look for: In addition, for the WEB interface, the perl scripts are using the modules DBI and DBD-Pg. The configuration program also check for them. If they are available on your machine, but not found by Pleinpot, you may try to understand why, or just leave Pleinpot install its own new version. (As long as Pleinpot is not installed in a standard location, but in a private location it should not be a source of version conflicts).

Server and database

By default Pleinpot will start the database server proccess (called postmaster) on the default port (5432). If this port is already occupied, you may choose another one with the configure option --with-postgres-port=nnnn (where nnn is the number you choosed).

To use a database and a server which is yet running outside of your new Pleinpot installation, you have to give the name of the database, and possibly the port, to the configure program. The following options must be used:

There is a last option concerning the database cluster: Before you build Pleinpot with a provided database server, you must (1) start the postmaster and (2) create the database with granting the access right.

Data administration

If your current installation of Pleinpot starts the database server process and own the database, the administration of the HyperLeda database will be always automatically done.
If instead you are using a provided server you may also choose to use the HyperLeda database administrated by another installation of Pleinpot. It may be particularly interesting when you are running different installations of Pleinpot in order to save disk space.
The configure option to specify how data must be administrated and accessed are:

HyperLeda Questions: leda@univ-lyon1.fr