Change postgres auth method (#24640)

https://github.com/apache/airflow/commit/20ca9c21d3453cceed1601dd26c032a92252c9c6