binkhq/ait-bootstrap-db

Boostraps Databases in AIT Cluster

DB Bootstrap

Simple project for use with the AIT Cluster, forcefully restores databases to a fresh postgres server

Dumped with:

$ for i in atlas eos europa hades hermes harmonia midas pontus
      pg_dump -C -c --if-exists --no-owner -d $i -h 127.0.0.1 -U goat -W > $i.psql
  end

Args:

• -C - Create, creates the database
• -c - Drop, the database before creating
• --if-exists - Add "if exists" into dumped SQL when truncating deleting, less client errors
• --no-owner - Doesn't dump database ownership info, less client errors
• -d Database Name
• -h Database Host
• -U Database User
• -W Force prompt for Database Password

Compressed with:

$ for i in *.psql
      zstd --rm $i
  end