Disclaimer: Generally we don't recommend that you should install a local server on your machine, but in some cases it can be nice to play around. Note that this will only help you install the SQL server and not any of the services we run on top of that in a normal full dRofus server installation. That means you will not be able to use the file/document store service, the report service and the user and project administration. You should also know that since this is not a “supported” way of installing dRoufs we will not guarantee that the database will work with other versions of the client than the one that was used when the database dump was made. Because of different encoding on local machines and servers you must use client dRofus0.9.0alfa5 and up.

The process consists of three steps:

1. Download and install PostgreSQL database
2. Restore a copy of an dRofus database locally
3. Create a user to the database
4. Log on to the local server

Note that if you want to restore a new copy or another database locally you only need to repeat step 2.

dRofus is running on top of the PostgreSQL database. It is a mature and advanced open-source database management system (like MS SQL and Oracle). To install this on Windows go to the download page and follow the instructions. The easiest is to use the one click installer provided by EnterpriceDB. dRofus is currently running on version 8.3. You can normally just click “next” until the setup is done. Please note the following:

1. Remember or write down the password you provide for the superuser during install (you will need it later)
2. Make sure that port is set up to run at 5432 (default value)
3. There is no need to “launch stack builder at exit” - just finish.

If you don't have a copy of this please contact us at developers@nosyko.no.

1. Open PgAdmin III which was installed during the installation of PostgreSQL. This is placed under the PostgreSQL folder in the start menu.
2. Double click on the server “PostgreSQL 8.3 (localhost)” and provide the password you entered when installing PostgreSQL.
3. Expand the server node and right click on “Databases” and select “new database”. Give the database a name and click OK.
4. Right click on the new database you created and select: “Restore”. Select the database dump you have received and make sure that “No owner” and “Disable trigger” is checked.

1. When you click OK it will take a minute or two and you get a log with information. Click cancel to close the dialog.

1. You need to create a role/user on the local server to access the database you created. Right click on “Login roles” and select “New login role”. Give the new role a role name (username) = “testrds” and choose a password. Make sure that “superuser” is checked:

When you have created the database and user you can login to the local server with the user you created in step 2 (testrds). Just start dRofus as normally (needs to be version 0.9.0alfa5 or higher because of the encoding). Use testrds as username and the pasword you gave when created the user. Server is localhost and database is the name you gave it in step 2 above.

You can also use PgAdmin III to browse down to the tables and views if you would like to see the data directly in the database, but this would normally need some explanation from Nosyko to explain how data is stored.