Codified PostgreSQL Schema - PGCon

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.

Google Online Preview   Download

To fulfill the demand for quickly locating and searching documents.

It is intelligent file search solution for home and business.

Literature Lottery

Related searches