implicit landing database with postgres

[alialkhalidi]

When configuring the database connection string, vct expects the following format:

postgres://USERNAME:PASSWORD@HOST:5432

which has an implicit assumption about the database name used to connect to the host; in this case it would be a database name matching the name of the username.

Even when specifying a (pre-created) database in the URI, vct treats connect the database as a prefix and fails:

 [vct] 2022/04/08 18:48:41 UTC - main.main -> CRITICAL failed to run vct: open store: failed to connect to database: failed to connect to `host=postgres user=vctdb database=newDB/vctdbconfig`: server error (FATAL: database "newDB/vctdbconfig" does not exist (SQLSTATE 3D000))

The suggestion is that since vct "at least" needs the config database, that would be the initial database it connects to, but does not create. yet it creates the "configured" log/alias-id database using the prefix.