Codified PostgreSQL Schema - PGCon
Codified PostgreSQL Schema
Idempotent Schema Migrations for Developers and DBAs
Sean Chittenden
Engineering
seanc@
@SeanChittenden
Getting Started
?
Terraform - terraform.io
?
?
PostgreSQL -
?
?
A database and schema to work with
An appreciation for version controlled software
?
2
A basic understanding of a Directed Acyclic Graph
Pick your poison: git, hg, fossil
Talk Agenda
3
?
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
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.