Lifehack #1: You need to import all postgis extensions right after postgres database creation to avoid type errors during database work. You can read how to connect postgis extensions to database
here. When all extensions are connected you are ready to connect database to server and check that all tables created as intended.