Upgrade to PostgreSQL 17.2.
See https://www.postgresql.org/about/news/postgresql-172-166-1510-1415-1318-and-1222-released-2965/
Upgrade to PostgreSQL 17.1.
See https://www.postgresql.org/about/news/postgresql-171-165-159-1414-1317-and-1221-released-2955/
Upgrade to PostgreSQL 17.0.
See https://www.postgresql.org/about/news/postgresql-17-released-2936/
Upgrade to PostgreSQL 16.4.
See https://www.postgresql.org/about/news/postgresql-164-158-1413-1316-1220-and-17-beta-3-released-2910/
Upgrade to PostgreSQL 16.3.
See https://www.postgresql.org/about/news/postgresql-163-157-1412-1315-and-1219-released-2858/
Upgrade to PostgreSQL 16.2.
See https://www.postgresql.org/about/news/postgresql-162-156-1411-1314-and-1218-released-2807/
Upgrade to PostgreSQL 16.1.
See https://www.postgresql.org/about/news/postgresql-161-155-1410-1313-1217-and-1122-released-2749/
Upgrade to PostgreSQL 16.0.
See https://www.postgresql.org/about/news/postgresql-16-released-2715/
Upgrade to PostgreSQL 15.4.
See https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/
Upgrade to PostgreSQL 15.3.
See https://www.postgresql.org/about/news/postgresql-153-148-1311-1215-and-1120-released-2637/
Upgrade to PostgreSQL 15.2.
See https://www.postgresql.org/about/news/postgresql-152-147-1310-1214-and-1119-released-2592/
Upgrade to PostgreSQL 15.1.
See https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/
- Add table country_flag
- Add some samples in city.local_name
- Fix some data in city for cities in France
- Use CSV for external data files
- Add city.local_name column
Upgrade to PostgreSQL 15.0.
See https://www.postgresql.org/about/news/postgresql-15-released-2526/
Upgrade to PostgreSQL 14.5.
See https://www.postgresql.org/about/news/postgresql-145-138-1212-1117-1022-and-15-beta-3-released-2496/
Upgrade to PostgreSQL 14.4.
See https://www.postgresql.org/about/news/postgresql-144-released-2470/
Upgrade to PostgreSQL 14.3.
See https://www.postgresql.org/about/news/postgresql-143-137-1211-1116-and-1021-released-2449/
Upgrade to PostgreSQL 14.
See https://www.postgresql.org/about/news/postgresql-14-released-2318/
Upgrade to PostgreSQL 13.
See https://www.postgresql.org/about/news/2077/
Upgrade to PostgreSQL 12.
See https://www.postgresql.org/about/news/1976/
Upgrade to PostgreSQL 11.
See https://www.postgresql.org/about/news/1894/
Add HEALTHCHECK in Dockerfile (#2).
Upgrade to PostgreSQL 10.
See https://www.postgresql.org/about/news/1786/
Simplify Dockerfile (no need for zipped SQL scripts)
Add country_fk (city.country_code -> country.code)
Upgrade to PostgreSQL 9.6.
Normalization : change table and columns names to snake case.
See also this question on SO : PostgreSQL naming conventions.
Initial release.
Based on PostgreSQL 9.5.
Source : world-1.0 database (2005-12-02).