echo /usr/lib/postgresql >> /etc/ld.so.conf ldconfig -v su postgres dropdb yourdb createdb --tablespace=yourdbname --owner=oname yourdb createlang plpgsql yourdb psql -d yourdb -f /usr/share/pgsql/contrib/lwpostgis.sql psql -d yourdb -f /usr/share/pgsql/contrib/spatial_ref_sys.sql
