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!

5 comments
Comment actions Permalink

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.

0
Comment actions Permalink

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.

0
Comment actions Permalink

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!

0
Comment actions Permalink

Yes, looks good.

0
Comment actions Permalink

Thank you!  I was able to succesfully migrate to the new database.  All good!

0

Please sign in to leave a comment.