Thanks to new resources (postgresql_default_priviledges) and some fixes Terraform can now add new databases and manage ownership / access to them.
This example creates new database and two users. You can use owner to create new tables and run migrations and user for normal read/write access to database.
| # This will run terraform fmt check on pull requests before planning | |
| # Requires atlantis >= 0.4.15 | |
| version: 2 | |
| automerge: true | |
| projects: | |
| - name: myproject | |
| dir: . | |
| workspace: default | |
| terraform_version: v0.11.11 |
Relates to: https://gist.github.com/magnetikonline/6215d9e80021c1f8de12
WARNING: all examples here also create user and access key - this secret key WILL be stored in state file.
| #### | |
| #### | |
| # Terraform manifest that creates spot fleet by copying attributed from currently running instance. | |
| # Is has a lot of copy-pasing due to two terraform 0.11 bugs | |
| # - tags with dots in key names forced to copy-paste them in this manifest | |
| # - instance data source does not provide user data script so it had to be manually copied to a file along with this manifest | |
| # both bugs are being worker on in terraform 0.12 | |
| data "aws_caller_identity" "current" {} |
I hereby claim:
To claim this, I am signing this object:
| set -e | |
| set -u | |
| SOURCE_REGION=us-west-2 | |
| DEST_REGION=eu-west-1 | |
| INSTANCE_IDENTIFIER=db-instance | |
| SNAPSHOT_ARN=$(aws rds describe-db-snapshots --region $SOURCE_REGION --db-instance-identifier "$INSTANCE_IDENTIFIER" \ | |
| --query "DBSnapshots[? Status=='available']" \ | |
| | jq -r 'sort_by(.SnapshotCreateTime) | .[-1] | .DBSnapshotArn') |
| DISK=/dev/xvdd | |
| VGNAME=vgjava | |
| LVNAME=lvjava | |
| pvcreate $DISK | |
| vgcreate $VGNAME $DISK | |
| lvcreate -l 100%free $VGNAME -n$LVNAME | |
| mkfs.ext4 /dev/$VGNAME/$LVNAME | |