The Dataverse Network Project

Install PostgreSQL and the pgAdmin utility. If you encounter problems installing PostgreSQL, be sure to check the Dataverse Network Forum for platform-specific information that might help you resolve issues.

Note: The JDBC driver used with PostgreSQL is packaged with the DVN core code.

To install and set up the DBMS:

1. Download and install PostgreSQL. Downloads for most platforms are available on the Downloads binary page.
   Specify the PostgreSQL service account and super-user account passwords as secret.
   Refer to the PostgreSQL FAQ and the PostgreSQL Installer for Windows documentation if you need assistance installing this component.
   Note: If you install to a Windows environment, be sure to install PostgreSQL as a service, which is the default. If you do not, you must start and stop the DBMS manually to use the DVN development environment.
2. Download and install the appropriate pgAdmin tool from the Graphical Clients list on the PostgreSQL Downloads page.
   Note: If you install to a Windows environment, the pgAdmin tool in included in the PostgreSQL download.
3. Start the PostgreSQL database server, open the pgAdmin tool, and connect to the PostgreSQL database server at http://localhost:5432.
4. Create a New Login Role.
   Set the username to dvnApp and the password to secret. Accept all default settings.
5. Create a new database.
   Set the database name to <your database name>, and the owner to dvnApp. Accept all default settings.
6. Restart the server.