Use postgresql instead of redis for statestore

[tmacam]

Description

Postgres is both a state store with real transactions and it is better suited to for handling Dapr workflows. As such, and given it is the recommended state store for Workflows, it makes sense to use it for the state store E2E tests.

Once we release to Dapr 1.12.0 we can upgrade it to use AAD authentication.

Issue reference

We strive to have all PR being opened based on an issue, where the problem or feature have been discussed prior to implementation.

Please reference the issue this PR will close: none

Checklist

Please make sure you've completed the relevant tasks for this PR, out of the following list:

• [ ] Code compiles correctly
• [ ] Created/updated tests
• [ ] Extended the documentation