seanbell / opensurfaces

Crowdsourcing pipeline and website for OpenSurfaces [SIG '13] and Intrinsic Images in the Wild [SIG '14]
http://opensurfaces.cs.cornell.edu/
MIT License
152 stars 41 forks source link

Specify template during createdb #4

Open kmatzen opened 8 years ago

kmatzen commented 8 years ago

I ran the existing install_postgres.sh script.

createdb: database creation failed: ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT:  Use the same encoding as in the template database, or use template0 as template.

Recommended update: Change

createdb -p $DB_PORT --owner=$DB_USER --encoding=UTF8 $DB_NAME

to

createdb -p $DB_PORT --owner=$DB_USER --encoding=UTF8 --template=template0 $DB_NAME

I can follow up with a PR if you're interested.