Add postgres backend and customize key (default workspace can it be changed )

[swtbahmed]

Terraform Version

terraform {
  required_providers {
    vsphere = {
      source  = "hashicorp/vsphere"
      version = "2.9.1"
    }
    vault = {
      source  = "hashicorp/vault"
      version = "4.4.0"
    }
  }
}

Affected Pages

No response

What is the docs issue?

am using terraform backend "pg"
it is by default keyed by workspaces .. is it possible to change that key to be dynamic not by workspaces that need to exist in advance..
i don't want to use workspaces

Proposal

the proposed is to change the default key from workspace ==> to key= dynamic value generated from terraform code using variables
is that possible

References

No response

[bschaatsbergen]

Hey @swtbahmed, thank you for raising this issue! I’m tagging @remilapeyre for visibility since they manage the Postgres backend. In the meantime, I find this backend quite interesting, so I’ll also do some research on it.

[swtbahmed]

@bschaatsbergen Thank you for the response i'll be waiting for @remilapeyre.
So i can explain more my issue. Thank you

[bschaatsbergen]

Please feel free to share your thoughts or challenges already. Doing so not only helps me consider potential solutions but also contributes to a public record that others can engage with as well.

[swtbahmed]

hello i can explain more the use case am facing :
Am working on creating multiple VMs and the goal is to save each tfsate file in a Column in pg database but what a find in docs that is keyed by default with workspace so i need to create a workspace for each vm i see it's not practical..
And i need to work on postgres any suggestion and i will be gratefull