Public data dump

[jrmerz]

How do create a public snapshot of the database?

The following fails if the library_user does not have full access to the database.

pg_dump -U library_user 

[jrmerz]

Currently looking at manual scan of database :( Would need to include:

• tables
  • indexes? (or just worry about the data)
• views
• materialized views
• functions

This would also require us figuring out the dependency graph for insert order.