Just follow the one click installer PostgreSQL 8.4 for windows. After finishing, you should have a running PostgreSQL 8.4.
Create a user¶
Start the pgadmin tool that came with the installation. It should show the Server which was just installed. Double click on it to connect as the postgres user. Use the password you were asked to create in the installation process.
Right click on "Login Roles" and make "New Login Role...".
Name the user mint and give him a password.
Check "Can create database objects" in "Role privileges" tab.
Go to the Variables tab and select the search_path Variable name. Enter "mint, public" as the Variable Value. Click OK to store the new User/Role.
Disconnect from the server.
Create a connection with the new mint user.¶
Click on the power plug and in the window "New Server Registration", and enter the following
Create a database¶
Click on the mint connection after that a tree appears. Right click on "Databases" and select "New Database..." and set the following. (NOTE: Select the collation and the character type installed in your system.)
Select the mint database and click the SQL toolbar button. Select
File -> Open, locate the createSchema.sql (.\Mint\src\main\webapp\WEB-INF\src) in your mint installation and load it. If you feel like it, edit the default organization and the admin password in the sql file. (You can do it later in the tool as well.) Execute the file with the green triangle "Execute Query" button in the toolbar.
Repeat the same procedure for the file upgrade_sql_thesauri_1_3.sql.
Your mint database is ready.
Unix Based Operating System¶
Create a database
sudo -u postgres createdb -E UTF8 mint
sudo -u postgres psql mint
create a user for the application
create user mint password 'mint' login;
set the user's search path
alter role mint set search_path to mint,public;
and grant database to the user
grant all on database mint to mint;
Locate the createSchema.sql in your mint installation (/Mint/src/main/webapp/WEB-INF/src)
Login again as mint
psql -h localhost -U mint mint
and read in the schema. Its helpful to be in the directory with the createSchema.sql
That should setup the schema! Run the update
After that, edit the postgresql.conf file - which is normally kept in the data directory (initdb installs a default copy there) - by setting
#constraint_exclusion = off constraint_exclusion = on
to enable quick xml_node table searches for uploads.
Deploy Web App¶
Make sure that you have downloaded Maven.
Go to the location where you have downloaded mint (./mint/) and execute.
Copy the produced mint-1.0-SNAPSHOT.war file from ./mint/target/ to TOMCAT_HOME/webapps/.
You should be able to access it, by default, at path /mint-1.0-SNAPSHOT. To verify that the deployment succeeded, start tomcat and point your browser at
Your browser should show the Mint login page shown below. (NOTE: Your login and password are set in the createSchema.sql )
Congratulations you have just installed MINT. You are now ready to use it