Codified PostgreSQL Schema - PGCon
[Pages:97]Codified PostgreSQL Schema
Idempotent Schema Migrations for Developers and DBAs
Sean Chittenden
Engineering seanc@ @SeanChittenden
Getting Started ? Terraform - terraform.io
? A basic understanding of a Directed Acyclic Graph
? PostgreSQL -
? A database and schema to work with
? An appreciation for version controlled software
? Pick your poison: git, hg, fossil
2
Talk Agenda ? Bootstrapping a database by hand ? Bootstrapping a Terraform repository ? Importing a database into Terraform ? Iterating the design of a schema in Terraform ? Explanation of what Terraform is doing under the hood ? Tips to avoid having Terraform become Terrorform
3
Bootstrapping a Database
$ psql postgres=# CREATE ROLE pgcon WITH PASSWORD't: ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.