1. Database migration from ec2 to RDS

Backup and restore DB

# pg_dump -Fc -v -h [instance endpoint] -U [master_username] [database] > [database].dump createdb [new database name] # pg_restore -v -h [instance endpoint] -U [master_username] -d [new database name] [database].dump

In below file changes required with following directives

# vi /etc/openproject/conf.d/00_addon_postgres export DATABASE_URL=”postgres://:@:5432/” # openproject restart

2. Set S3 bucket for storage for attachments

# vi /etc/openproject/conf.d/other

Comment the below line

#export ATTACHMENTS_STORAGE_PATH=”/var/db/openproject/files”

And, add the below directives at the end of file

export OPENPROJECT_ATTACHMENTS__STORAGE=fog export OPENPROJECT_FOG_DIRECTORY=”myprojectbucket” export OPENPROJECT_FOG_CREDENTIALS_PROVIDER=”AWS” export OPENPROJECT_FOG_CREDENTIALS_AWS__ACCESS__KEY__ID=”AKIA5ETJJ6AFRZEUQELV” export OPENPROJECT_FOG_CREDENTIALS_AWS__SECRET__ACCESS__KEY=”CYBkt33ZYhlAJnXCK6WoAUC3ZPRjhvoNXYy0qFL5″ export FOG_CREDENTIALS_REGION=”us-east-1″

Save and quit command line editor

And restart the open project.

# sudo service openproject restart