I gave a talk at PGConf US 2019 on some of the many ways you can load data into PostgreSQL using open source tools.
This is similar to the talk I gave last year but with the addition of the pgloader commandline tool and the http PostgreSQL extension.
HTML slides PDF slides
Even though it was a talk Not much about PostGIS, but just tricks for loading data, I managed to get a mouthful of PostGIS in there.
