Migration from Internal to External Database (postgres)
The internal Data is grown to 9G almost.
I am trying to migrate the Database, using ./maintaindb.sh
I am able to make succesfull connection, but Exporting Tables is taking like ages.
Last time it took me 8+ hours to Export the tables.
Is there any way I can increase speed the process and I believe this maintainDB script is backing up the data, is there any way to exclude the back up and directly do migration ?
To let you know I hace increase the TEAMCITY_MAINTAINDB_MEM_OPTS="-Xmx24G"
Please sign in to leave a comment.
Hello Varun,
The process of migration is always a backup followed by a restore -- you can't migrate your database "on the fly", omitting creation of a ZIP file.
When working with the internal (HSQL) database, you may need Java heap 3-4 times larger than your data volume, so a 24 GB heap is "normal".
Generally, HSQL is not intended to hold the amount of data that huge, so I suggest you migrate to PostgreSQL or any other supported external database as soon as possible.
Regards,
Andrey.