The demo database is available at edu.postgrespro.com in three flavors, which differ only in the data size:
The small database is good for writing queries, and it will not take up much disk space. The large database can help you understand the query behavior on large data volumes and consider query optimization.
The files include an SQL script that creates the
demo database and fills it with data (virtually, it is a backup copy created with the pg_dump utility). The owner of the
demo database will be the DBMS user who runs the script. For example, to create the small database, run the script as the user
postgres by means of psql:
psql -f demo_small_YYYYMMDD.sql -U postgres
Note that if the
demo database already exists, it will be deleted and recreated!