Teamcity migration from internal DB to Postgres
Hi All,
I am trying to migrate Teamcity to external DB. The current DB has grown to size 320 MB.
Please find log below, let me know for any suggestions, how to debug this.
[root@tc-staging1 bin]# ./maintainDB.sh migrate -A /root/.BuildServer -T /root/.BuildServer/config/database.properties
../webapps/ROOT/WEB-INF/lib
Using logs directory /home/teamcity/TeamCity/logs
TeamCity maintenance tool. Copyright 2015 JetBrains s.r.o. All Rights Reserved.
Command line arguments: migrate -A /root/.BuildServer -T /root/.BuildServer/config/database.properties
Using TeamCity data directory: /root/.BuildServer
Using database settings from the TeamCity data directory for source database: /root/.BuildServer/config/database.properties
Using source database
database type: POSTGRESQL
connection string: jdbc:postgresql://localhost:5432/teamcitydb
Source JDBC driver version 8.4 (PostgreSQL Native Driver)
Source database system version 8.4.9 (PostgreSQL)
Cannot proceed with 'migrate' command: The source database is empty.
Critical error has occurred during command execution.
[root@tc-staging1 bin]# ./maintainDB.sh migrate -A /root/.BuildServer -T /root/.BuildServer/config/database.properties
Thanks,
Prashanth L
Please sign in to leave a comment.
I ran restore command, this works fine. Thanks.
./maintainDB.sh restore -F /root/.BuildServer/backup/TeamCity_Backup_20160229_100130.zip -T /root/.BuildServer/config/database.properties -D
Hi Prashanth,
Glad that the problem is sorted out!
FYI: there are some examples how to use maintainDB tool to restore database in the documentation: https://confluence.jetbrains.com/display/TCD9/Restoring+TeamCity+Data+from+Backup.