setup_edifice.py on ubuntu 12.10 asks for a password

[spwntr]

on ubuntu 12.10 with all prerequisites ran:

python setup_edifice.py --create_template

output:

Initializing postgres with a basic PostGIS template using the postgres superuser. db_names is ['postgres', 'template0'] EDIFICE_DB is edifice createdb -U postgres -h localhost -T template0 -E UTF8 base_postgis Password:

thanks.

[mccc]

Your postgres superuser has a password enabled, so createdb (run as superuser) is asking for a password. Unless we write our own little password wrapper, the setup_edifice script (especially in --create_template mode) will prompt you for postgres superuser passwords a few times. On the other hand the --create mode should only need permissions for the 'edifice' non-superuser.

[spwntr]

after setting a password for "postgres" it accepted one for --create_template but still gave errors:

Initializing postgres with a basic PostGIS template using the postgres superuser. db_names is ['bug', 'postgres', 'template0'] EDIFICE_DB is edifice createdb -U postgres -h localhost -T template0 -E UTF8 base_postgis Password: psql -U postgres -h localhost -d base_postgis -c CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; Password for user postgres: ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/postgis.control": No such file or directory psql -U postgres -h localhost -d postgres -c UPDATE pg_database SET datistemplate='true' WHERE datname='base_postgis'; Password for user postgres: UPDATE 1 psql -U postgres -h localhost -d base_postgis -c GRANT ALL ON geometry_columns TO PUBLIC; Password for user postgres: ERROR: relation "geometry_columns" does not exist psql -U postgres -h localhost -d base_postgis -c GRANT ALL ON geography_columns TO PUBLIC; Password for user postgres: ERROR: relation "geography_columns" does not exist psql -U postgres -h localhost -d base_postgis -c GRANT ALL ON spatial_ref_sys TO PUBLIC; Password for user postgres: ERROR: relation "spatial_ref_sys" does not exist psql -U postgres -h localhost -d base_postgis -c CREATE USER edifice; Password for user postgres: CREATE ROLE psql -U postgres -h localhost -d base_postgis -c ALTER USER edifice createdb; Password for user postgres: ALTER ROLE

and without setting an "edifice" password, --create still asked for a password:

Setting up edifice database from scratch. dropdb -U edifice -h localhost --interactive edifice Database "edifice" will be permanently removed. Are you sure? (y/n) y Password: dropdb: could not connect to database postgres: FATAL: password authentication failed for user "edifice" FATAL: password authentication failed for user "edifice" createdb -U edifice -h localhost -T base_postgis edifice Password: createdb: could not connect to database postgres: fe_sendauth: no password supplied psql -U edifice -h localhost -d edifice -f sql_init_scripts/pins_master.sql Password for user edifice: psql: fe_sendauth: no password supplied psql -U edifice -h localhost -d edifice -f sql_init_scripts/edifice_initialization_script.sql Password for user edifice: psql: fe_sendauth: no password supplied psql -U edifice -h localhost -d edifice -c CREATE SCHEMA dataportal IF NOT EXISTS; Password for user edifice: psql: fe_sendauth: no password supplied Fetching pins.dump... wget -O downloads/pins.dump http://dl.dropbox.com/u/14915791/pins.dump --2013-02-12 23:16:12-- http://dl.dropbox.com/u/14915791/pins.dump Resolving dl.dropbox.com (dl.dropbox.com)... 54.243.103.62, 54.243.118.43, 107.21.253.161, ... Connecting to dl.dropbox.com (dl.dropbox.com)|54.243.103.62|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 69817910 (67M) [application/octet-stream] Saving to: `downloads/pins.dump'

100%[====================================================================================================>] 69,817,910 1.24M/s in 54s

2013-02-12 23:17:08 (1.23 MB/s) - `downloads/pins.dump' saved [69817910/69817910]

Loading property pins... pg_restore -U edifice -h localhost -O -c -d edifice downloads/pins.dump Password:

[mccc]

According to this:

http://blog.gmane.org/gmane.comp.gis.postgis/month=20121001

Ubuntu does not have a simple install for PostGIS.

This seems like the current canonical page for getting it working:

http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src

Try to follow these instructions, and you can stop before the header 'Spatially enabling a database' because that is what setup_edifice.py --create_template should do for you.