April 29, 2016, 6:21 a.m.
encodings for database "postgres" do not match: old "UTF8", new "SQL_ASCII" can be overcome by using /usr/pgsql-9.5/bin/initdb -E 'UTF-8' 9.5 as mentioned in the manual. When you run pg_upgrade, you must provide the following information:   ...
May 16, 2015, 4:11 a.m.
Which PostGIS function or operator do you use if you wanted to find the overlap between different lines? There are several candidates with ~, && , ST_Overlaps and and ST_Intersect being amongst the most prominent. They all do the job in different way and take different amounts of time a ...