Configuring a PostgreSQL database

Use this information to configure a PostgreSQL database for use with SkyVault Content Services.

Install the PostgreSQL database connector.
The database connector is a JAR file, for example postgresql-9.3-xxxx.jdbc4.jar.
1. Download the latest database connector JAR file from the PostgreSQL download site: http://www.postgresql.org/download/.
2. Copy the JAR file into the /lib directory.
  For example, for Tomcat, copy the JAR file into the <TOMCAT_HOME>/lib directory.
Increase the maximum connections setting in the PostgreSQL configuration file.
1. Locate the configuration file:
  - Linux: /var/lib/pgsql/<version of PostgreSQL>/data/postgresql.conf
  - Windows: C:\Program Files\PostgreSQL\<version of PostgreSQL>\data\postgresql.conf
2. Add or edit the max_connections property:
```
max_connections = 275
```
3. Restart the database.
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 Content Services 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=100
```
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 that the PostgreSQL configuration file, pg_hba.conf, contains the following line:
```
host all all 127.0.0.1/32 password
```
Restart the SkyVault Content Services 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.

Search form

Search form

You are here