Changes between Version 1 and Version 2 of UsersWikiPostGIS23UbuntuPGSQL96Apt


Ignore:
Timestamp:
Mar 25, 2017, 9:27:08 AM (7 years ago)
Author:
robe
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiPostGIS23UbuntuPGSQL96Apt

    v1 v2  
    214214
    215215{{{
    216 sudo su - postgres
    217 }}}
    218 
    219 {{{
    220 createuser -d -E -i -l -P -r -s yourUserName
    221 }}}
    222 
    223 (be sure to change the username to your desired username)
    224 
    225 Enter your new password when prompted
    226 
    227 Log out as {{{postgres}}} user:
    228 
    229 {{{
    230 exit
    231 }}}
    232 
    233 Exit terminal:
    234 
    235 {{{
    236 exit
     216sudo -u postgres psql
     217CREATE ROLE mysuperuser LOGIN PASSWORD 'whatever' SUPERUSER;
    237218}}}
    238219
    … …  
    242223
    243224Another handy piece of software {{{shp2pgsql-gui}}} tool. This will allow you to quickly connect to your new PostGIS database and import a Shapefile.
     225Note this will only work if you have Ubuntu with a desktop (not a headless Ubuntu)
    244226
    245227Open terminal, and type: