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 […]