I have just moved my old TeamCity installation to a new computer, along with postgres database backup.
I have successfully restored the postgres backup, was able to see the data in tables (projects, users etc).
After the first start of TeamCity I realised that I have forgotten the password for admin account, but still remembered the one for guest, so I went to the database and upated teh "users" table accordingly.
After I started TeamCity and logged in I have discovered, to my huge surprise, that all teh projects are in fact gone.
I checked the table "projects" and they were not there as well.
So my question is - why does that happen and how can I avoid it? Is there a process to follow when restoring backups?