PostGresSQL to PostGresSQL 9.3 DB migration
Hello,
I'm using TeamCity 8.0.5 (build 27692) running on PostGresSQL 8.1 database. Is PostGresSQL 9.3 a supported database?
Also reviewing the documentation, I assume I can just run the maintainDB script to migrate to the new PostgresSQL database?
Is there anything else I should be aware of?
Thanks!
Please sign in to leave a comment.
Hello, we tested TC with PG 9.3 and had no compatibility issues. There are two ways to upgrade: backup TC database and restore it on 9.3 or migrate database database itself without using TC scripts. Both ways should be okay, but it's highly recommended to backup your database before upgrade regardless off the way you chose.
Thank you! I think I will backup the postGresSQL database and then restore it on the 9.3 postGresSQL database. I will also do a teamcity database back prior to migrating to the new 9.3 database.
I've read through the documentation again and I'm not seeing where I do a PostGresSQL backup from the old server and restore it on the new 9.3 server. Can you confirm, these are the correct steps?
1. Using TeamCity web-ui, do a teamcity backup. Shutdown TeamCity when completed.
2. Install 9.3 JDBC Driver.
3. Update database.properties to point to new 9.3 DB Server.
2. Do a PostGresSQL database backup on old DB server.
3. Restore PostGresSQL database backup to new 9.3 PostGres DB server.
4. Startup TeamCity and verify it's accessing the new 9.3 PostGres DB server.
Thanks!
Yes, looks good.
Thank you! I was able to succesfully migrate to the new database. All good!