edm‐data - NYCPlanning/data-engineering GitHub Wiki

For most product builds, we use our persistent Postgres DB cluster named edm-data. Each product has it's own DB.

Creating a new database

To create a new DB for a product using DBeaver:

1. Right click on edm-data in the Navigator panel and select Connection View -> Advanced

2. Right click on edm-data and select Create -> Database

3. For database name, use our convention of db-product-name

4. Change the Tablespace selection from pg_default to Default

5. Click OK

6. Add the postgres extensions we typically use in a build:

   CREATE EXTENSION postgis;
   CREATE EXTENSION fuzzystrmatch;