load_postgis_1.x_in_postgis_2.x.py

load_postgis_1.x_in_postgis_2.x.py

import os

db_dump = "./mydump"
db_user = "postgres"
db_name = "mydatabase"

os.system("dropdb -U %s %s" % (db_user, db_name))
os.system("createdb -U %s %s" % (db_user, db_name))
os.system("psql -U %s -d %s -c 'CREATE EXTENSION postgis';" % (
    db_user,
    db_name
))
os.system("psql -U %s -d %s -f /usr/share/postgresql/9.3/contrib/postgis-2.1/legacy.sql;" % (
    db_user,
    db_name
))
os.system("psql -U %s -d %s -c 'ALTER TABLE spatial_ref_sys ADD CONSTRAINT spatial_ref_sys_srid_check check (srid > 0 AND srid < 999000 )';" % (
    db_user,
    db_name
))
os.system("psql -U %s -d %s -c 'ALTER TABLE spatial_ref_sys ADD PRIMARY KEY(srid));';" % (
    db_user,
    db_name
))
os.system("/usr/share/postgresql/9.3/contrib/postgis-2.1/postgis_restore.pl %s | psql -U %s -d %s 2> errors.txt" % (
    db_dump,
    db_user,
    db_name,
))