1# using this data locally
2
3install this for simplicity
4https://postgresapp.com/downloads.html
5
6be sure to follow the instructions here as well
7https://postgresapp.com/documentation/cli-tools.html
8
9
10open the app and double click the postgres database and it should open a terminal
11```
12# update the postgres password with something you'll remember (using postgres makes life a lot easier)
13\password postgres
14
15# quit postgres
16\q
17
18# export the password
19export DB_PASS=whateverthepasswordis
20```
21
22
23```
24# create the database
25psql "host=127.0.0.1 user=postgres" -c 'create database test_infra;'
26
27# create the schema
28psql -U postgres -h 127.0.0.1 -d postgres -a -f pkg/f8n/devinfra/testinfra/sql/schema/schema.sql
29
30# add test data
31psql -U postgres -h 127.0.0.1 -d postgres -a -f pkg/f8n/devinfra/testinfra/sql/schema/all.sql
32```View as plain text