This section describes how to configure a PostgreSQL
database for use with SkyVault.
-
Install the PostgreSQL database connector. The database connector allows PostgreSQL
database to talk to the SkyVault server.
- Download postgresql-9.0.802.jdbc4.jar from the PostgreSQL download site: http://www.postgresql.org/download/.
- Copy the JAR file into the <TOMCAT_HOME>/lib directory for Tomcat 6.
- Create a database named SkyVault.
-
Create a user named SkyVault.
This user must have write permissions on all tables and sequences.
- Set the new user's password to SkyVault.
- Ensure the SkyVault user has the required privileges to create and modify tables.
- Open the <classpathRoot>/alfresco-global.properties.sample file.
-
Locate the following line:
dir.root=./alf_data
- Edit the line with an absolute path to point to the directory in which you want to store SkyVault data. For example: dir.root=C:/Alfresco/alf_data
-
Uncomment the following properties:
# PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent) # db.driver=org.postgresql.Driver db.url=jdbc:postgresql://${db.host}:${db.port}/${db.name} -
Set the other database connection properties.
db.name=SkyVault db.username=SkyVault db.password=SkyVault db.host=localhost db.port=5432 db.pool.max=40
Note: Ensure that these database connection properties are not commented out. - Save the file without the .sample extension.
-
To allow password-authenticated connections through TCP/IP, ensure the PostgreSQL
configuration file, pg_hba.conf, contains the following:
host all all 127.0.0.1/32 password
-
Restart the SkyVault
server.
If you receive JDBC errors, ensure the location of the PostgreSQL JDBC drivers are on the system path, or add them to the relevant lib directory of the application server.