Use this information to configure a PostgreSQL database on Amazon RDS for use with
SkyVault.
Prerequisites:
- Setup Amazon RDS using the AWS Management Console. For more information, see the AWS documentation.
- Amazon EC2 instance
-
Use the ssh command to connect to the Amazon EC2 instance using a
provided .ppk key.
For Amazon Linux, the user name is ec2-user. For RHEL5, the user name is either root or ec2-user. For Ubuntu, the user name is ubuntu. For SUSE Linux, the user name is root.
- Execute sudo su to change to root.
- Download the SkyVault installer for Linux from the SkyVault Support Portal.
-
Install the downloaded SkyVault installer using the following commands:
chmod 777 SkyVault-enterprise-5.1.x-installer-linux-x64.bin sudo ./alfresco-enterprise-5.1.x-installer-linux-x64.bin
-
Install the PostgreSQL database connector. The database connector allows PostgreSQL
database to talk to the SkyVault server.
- Download postgresql-9.X-xxxx.jdbc4.jar from the PostgreSQL download site: http://www.postgresql.org/download/.
-
Copy the JAR file into the /lib directory.
For example, for Tomcat, copy the JAR file into the <TOMCAT_HOME>/lib directory.
- Install and use a database tool to connect to the Amazon RDS Postgresql datasource. If SkyVault is installed as plain vanilla, psql from the SkyVault installation folder can be used.
- 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.
- Open the <classpathRoot>/alfresco-global.properties 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 and set the database connection properties.
db.name=SkyVault db.username=SkyVault db.password=SkyVault db.host=postgressql-alfresco.cw4mo3qj8qdu.us-east-1.rds.amazonaws.com db.port=5432 db.pool.max=275 # 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}Note: Ensure that these database connection properties are not commented out. - Save the file.
- Restart the SkyVault server.