"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "website/docs/language/settings/backends/pg.html.md" between
terraform-1.0.2.tar.gz and terraform-1.0.3.tar.gz

About: Terraform is a tool for building, changing, and versioning a datacenter infrastructure (written in Go).

pg.html.md  (terraform-1.0.2):pg.html.md  (terraform-1.0.3)
skipping to change at line 76 skipping to change at line 76
} }
} }
``` ```
## Configuration Variables ## Configuration Variables
The following configuration options or environment variables are supported: The following configuration options or environment variables are supported:
* `conn_str` - (Required) Postgres connection string; a `postgres://` URL * `conn_str` - (Required) Postgres connection string; a `postgres://` URL
* `schema_name` - Name of the automatically-managed Postgres schema, default `t erraform_remote_state`. * `schema_name` - Name of the automatically-managed Postgres schema, default `t erraform_remote_state`.
* `skip_schema_creation` - If set to `true`, the Postgres schema must already e * `skip_schema_creation` - If set to `true`, the Postgres schema must already e
xist. Terraform won't try to create the schema. Useful when the Postgres user do xist. Terraform won't try to create the schema, this is useful when it has alrea
es not have "create schema" permission on the database. dy been created by a database administrator.
* `skip_table_creation` - If set to `true`, the Postgres table must already exi * `skip_table_creation` - If set to `true`, the Postgres table must already exi
st. Terraform won't try to create the table. Useful when the Postgres user does st. Terraform won't try to create the table, this is useful when it has already
not have "create table" permission on the database. been created by a database administrator.
* `skip_index_creation` - If set to `true`, the Postgres index must already exi * `skip_index_creation` - If set to `true`, the Postgres index must already exi
st. Terraform won't try to create the index. Useful when the Postgres user does st. Terraform won't try to create the index, this is useful when it has already
not have "create index" permission on the database. been created by a database administrator.
## Technical Design ## Technical Design
This backend creates one table **states** in the automatically-managed Postgres schema configured by the `schema_name` variable. This backend creates one table **states** in the automatically-managed Postgres schema configured by the `schema_name` variable.
The table is keyed by the [workspace](/docs/language/state/workspaces.html) name . If workspaces are not in use, the name `default` is used. The table is keyed by the [workspace](/docs/language/state/workspaces.html) name . If workspaces are not in use, the name `default` is used.
Locking is supported using [Postgres advisory locks](https://www.postgresql.org/ docs/9.5/explicit-locking.html#ADVISORY-LOCKS). [`force-unlock`](https://www.ter raform.io/docs/cli/commands/force-unlock.html) is not supported, because these d atabase-native locks will automatically unlock when the session is aborted or th e connection fails. To see outstanding locks in a Postgres server, use the [`pg_ locks` system view](https://www.postgresql.org/docs/9.5/view-pg-locks.html). Locking is supported using [Postgres advisory locks](https://www.postgresql.org/ docs/9.5/explicit-locking.html#ADVISORY-LOCKS). [`force-unlock`](https://www.ter raform.io/docs/cli/commands/force-unlock.html) is not supported, because these d atabase-native locks will automatically unlock when the session is aborted or th e connection fails. To see outstanding locks in a Postgres server, use the [`pg_ locks` system view](https://www.postgresql.org/docs/9.5/view-pg-locks.html).
The **states** table contains: The **states** table contains:
 End of changes. 1 change blocks. 
9 lines changed or deleted 9 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)