we have no one who supports postgreSQL here and was wondering if we can use different software for Analytics
Interested in this as well. We have a fleet of DBAs for Oracle and MSSQL.
As of current, as the manual/compatibility matrix only have PostgresSQL list for its supported database option for the analytics datastore. If there are any particular alternative you want, I would recommend creating a Ideas on the Community for PM to consider (and for anyone else on the Community interested on to vote along side with you).
There already an ideas that previously created Support Other DBs for AWA Analytics (This one does not list any particular DB, specially Oracle DB).