Skip to content

More permission and schema improvements

Compare
Choose a tag to compare
@thesteve0 thesteve0 released this 15 Jul 20:05
· 2 commits to master since this release

We no longer support individual csv files with instructions on how to load each file. This data was dumped from a PostgreSQL 11 database.

This release did some minor improvements to permissions and moved all tables into the public schema.

Here is the command we used to export the data:

pg_dump -h localhost -U postgres -Fp --compress=9 --no-owner --no-privileges -d workshop -f crunchy-demo-data.dump.sql.gz

and here is an example of the command you can use to restore the database

gunzip -c crunchy-demo-data.dump.sql.gz |psql -h localhost -U postgres -p 5432 workshop

If you use a non-privileged user you may have trouble loading the data since the exported database uses PostGIS. Make sure to add PostGIS to your database before importing the data