Then some SQL scripts containing vital mapping-related instructions need to be executed. You have to create a user in Postgresql that will be used to create all tables and data. In particular, you might find it necessary to make the user a postgres administrator (you will be asked for this when creating the user), to simplify user permissions. If needed, the commands 'dropdb gis' and 'dropuser gisuser' can be used. C:\Program Files\PostgreSQL\8.3\bin) in an command prompt run as Administrator, then running:Ĭ:\Program Files\PostgreSQL\8.3\bin\createuser -U postgres gisuserĬ:\Program Files\PostgreSQL\8.3\bin\createdb -U postgres -E UTF8 -O gisuser gisĬ:\Program Files\PostgreSQL\8.3\bin\createlang -U postgres plpgsql gis These commands can be issued from the Admin tool GUI or run by navigating to the bin directory (e.g.
Sudo -u postgres createdb -encoding =UTF8 -owner =gisuser gis
