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.
Related download
- add column with foreign key postgres
- psql v12 sp1 known issues general release june
- codified postgresql schema pgcon
- spring boot postgresql create database if not exists
- add column if not exists postgres
- pg stat statements does not exist
- introduction to hacking postgresql
- tda357 dit621 databases
- known issues psql11sp3 actian
- postgresql tuning for oracle dbas