This repo contains components for building the postgres_air database, which can be used for training and various performance experiments. The database is created by hDBn (Hettie Dombrovskaya & Boris Novikov)
This shared directory contains a data dump of the postgres_air schema in three formats: directory format, the default pg_dump format and compressed SQL format.
The total size of each is about 1.2 GB. Use the directory format, if you prefer to download smaller files. Use SQL if you want to avoid warnings about object ownership.
For directory format and default format, use pg_restore. For SQL, unzip the file and use psql for restore.
You can also use the QR code provided in the QR_download file to access this directory.
See the db_objects_description.txt file.
-
The Global Airport Database https://www.partow.net/miscellaneous/airportdatabase/index.html#GlobalAirportDatabaseLicens
-
Airport, airline and route data https://openflights.org/data.html
-
Airbus - All Aircraft & Prices, Specs, Photos, Interior, Seating - Aircraft Compare https://www.aircraftcompare.com/manufacturers/airbus/
-
Frequently Occurring Surnames from the 2010 Census https://www.census.gov/topics/population/genealogy/data/2010_surnames.html
-
Most Common Surnames [Last Names] in the United States (top 1000) https://namecensus.com/most_common_surnames.htm
-
First names male: https://namecensus.com/male_names.htm
-
First names female: https://namecensus.com/female_names.htm
Hettie and Boris do not guarantee the 100% accuracy of the data. We tried our best, but it is still possible that some airports ended up in the wrong cities and some cities ended up in the wrong countries. No offense intended in any of the above cases!
The flights' schedules are 100% imaginary; we guarantee that the flights' durations are realistic and each airport is reachable from any other airport, but the schedule does not resemble any real airline schedule.
Use at your own risk.