Skip to content

handle "standalone" databases (or single-database-instance)

Single-database-instances is a quite common use case nowadays (some call this a "micro-service instance") so we should expose some commands and APIs to manage such situations.

  • At database creation, when no instance is specified, create an eponymous instance.
  • At database update, assuming the underlying instance is named after the database.
  • For satellite services, e.g. pgbackrest, name them according to the database name.
  • Have dedicated role created after the database name, with only permission on that database.
  • See how instances-related options would be meaningful or not in this configuration, esp. "roles" (should these be roles only permitted on the database at stake?)
  • (probably more things to do, to be determined during the implementation)
Edited by Denis Laxalde
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information