fix: unable to create database on postgresql 12 and 13

[alehostert]

We're unable to create a database on PostgreSQL, versions 12 and 13.

Changing the authentication method to md5 on pg_hba.conf fixes the issue:

- local   all             postgres                                peer
+ local   all             postgres                                md5

Steps to reproduce

os db create --db-type postgresql --db-name test

2025-11-28T19:33:26Z ERR CreateDatabaseError err="{\"stdErr\":\"psql: error: connection to server on socket \\\"/var/run/postgresql/.s.PGSQL.5432\\\" failed: FATAL:  password authentication failed for user \\\"postgres\\\"\\npassword retrieved from file \\\"/root/.pgpass\\\"\\n\",\"exitCode\":2}"
{
  "status": "infraError",
  "body": "CreateDatabaseInfraError"
}