Use following command to use Postgres as database for your new site.

bench new-site <site-name> --db-type postgres

Note: Make sure you have Postgres version 9 or greater installed in your system.