Setup database accessibility for embedding database

Details

• Point of contact for this request: @devin

SRE Support Needed

We have a new database at patroni-embedding-01-db-gstg.c.gitlab-staging-1.internal which was manually created and a few things are currently not working:

• Patroni cluster not running
• Database stops without much information (patroni misconfiguration?)
• monitoring is giving errors for missing functions and tables
• Test pgbouncer

This is related to https://gitlab.com/gitlab-com/gl-infra/reliability/-/issues/23472 - There have been a few terraform and chef MR's used to create things, which are linked from that issue. The terraform and chef seems to be working correctly, but there is no existing database and schema to work with.