I am currently using Hobby dev plan, and will soon switch to Standard 1X. Will I still be able to use the current postgres DB (free one) or I need to upgrade as well?
You can totally use the free db with the standard or hobby dynos. There is no forced link between these plans.