Unanswered: cannot connect to database at hosting company
i cannot connect to the database at my hosting company. it gives the error 'no pg_hba.conf entry for host "127.0.0.1", user "username", database "template1", ssl off'. i believe i do not have access to the database template1. i have tried adding my database to the list of advanced connections on the advanced settings tab, but navicat still attempts to open template1. all the other postgresql clients i have evaluated have connected flawlessly.