If having a specific version of a tool is important for your work, it’s probably best to install that tool separate from homebrew and manage that install separately. The Postgres docs seem to recommend the EDB installer.

https://www.postgresql.org/download/macosx/

Likewise Python and other programming tools where running a specific version is important are best managed outside homebrew.