Revision 2037
Added by Aaron Marcuse-Kubitza almost 13 years ago
| Makefile | ||
|---|---|---|
| 166 | 166 |
mk_db: _always |
| 167 | 167 |
@$(confirmRmDb) |
| 168 | 168 |
-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin) |
| 169 |
-echo "CREATE DATABASE vegbien WITH OWNER bien TEMPLATE template0 \
|
|
| 169 |
-echo "CREATE DATABASE vegbien WITH OWNER bien TEMPLATE template1 \
|
|
| 170 | 170 |
ENCODING 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';"|$(psqlAsAdmin) |
| 171 | 171 |
echo $(rmPublicSchema)|$(psqlAsAdmin) vegbien |
| 172 |
$(createPlpgsql) |
|
| 173 | 172 |
# ignore errors if user or database exists |
| 174 | 173 |
# drop public schema *as admin* because it starts out owned by postgres |
| 175 |
createPlpgsql := echo 'CREATE PROCEDURAL LANGUAGE plpgsql;'\ |
|
| 176 |
|bin/db_dump_localize|$(psqlAsBien) |
|
| 177 | 174 |
|
| 178 | 175 |
rm_db: _always |
| 179 | 176 |
@$(confirmRmDb) |
Also available in: Unified diff
main Makefile: VegBIEN DB: mk_db: Use template1 because it has PROCEDURAL LANGUAGE plpgsql already installed and we aren't using an encoding other than UTF8