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="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" export FOG_CREDENTIALS_REGION="us-east-1"
Save and quit command line editor
And restart the open project.
# sudo service openproject restart