Users updating from Proximity 4.0 or later versions may choose to stay with their current MonetDB installation (MonetDB 4.6.2) or update to MonetDB Mars (4.20 for Linux/Mac OS X, 4.18.2 for Windows). The later MonetDB versions provide some performance improvements, but as the underlying database formats are not compatible, using these versions also requires converting existing databases to the newer format. See “Updating MonetDB Databases” later in this appendix for instructions on converting MonetDB 4.6.2 databases for use with MonetDB Mars.
See “Running the MonetDB database server” in Chapter 2, Getting Started with Proximity for information on using the MonetDB server with Proximity. Full MonetDB documentation is available from CWI’s website at monetdb.cwi.nl/projects/monetdb/MonetDB/Version4/Documentation/index.html.
Installing MonetDB for Linux/Mac OS X platforms
You must have administrator privileges (either by using
sudo or being logged in as “root”)
to install MonetDB.
Change directories to /usr/local.
> cd /usr/local
The Linux/Mac OS X binary distribution of MonetDB is not relocatable.
Extract the distribution. You must have a version of tar (e.g., GNU tar) that supports long file names.
> tar xvfz path-to-tarfile/monet-mars-distr-platform.tgz
where platform reflects your operating system.
Change permissions for the Monet-mars/var
directory to permit write access.
>cd /usr/local/Monet-mars>chmod -R a+w var
Installing MonetDB for Windows platforms
The Windows version of the MonetDB sever requires Windows 2000 Professional or later. You must be logged in as a user with administrator privileges to install MonetDB.
If you have an older version of MonetDB already installed on your
system, remove the following DLL files from the
C:\WINDOWS\System32\ directory:
libstream.dll
libmutils.dll
libMonetODBCs.dll
libMonetODBS.dll
libMapi.dll
Extract the installation files using WinZip or an equivalent application.
Run the Microsoft installer for MonetDB,
monet-mars-distr-win.msi, by
double-clicking the file name
to start the installation wizard. Follow the instructions to install
the MonetDB server in the desired location. The default installation
directory is C:\Program Files\CWI\MonetDB.
Proximity does not require the MonetDB ODBC driver. You can unselect this option on the third page of the installation wizard if you plan to only use MonetDB to serve Proximity databases. You can ignore warnings that “installation will fail if this component is not installed” if you are not installing the MonetDB ODBC driver; this warning refers to installing the MonetDB ODBC driver without having other required software already installed.
Your choice of installing MonetDB for “Just me” versus “All users” affects only whether MonetDB is added to the Start Menu for the current user or for all users. In all cases MonetDB stores its databases in
C:\\Documents and Settings\username\Application Data\MonetDB4\dbfarm\
where username is the login name for the
current user.
Run Mserver.bat (located in the installation directory).
> C:\\Documents and Settings\username\Application Data\MonetDB4\dbfarm\Mserver.bat
where username is the login name of the
current user.
This creates the required directory hierarchy for MonetDB data files.
Substitute the appropriate path if you installed the Monet
server someplace other than the default location.
Enter quit(); at the Monet server prompt to
quit the server (note the parentheses and semi-colon).
[Optional] Add the MonetDB installation directory to
PATH.