Revision 1937
Added by Aaron Marcuse-Kubitza almost 13 years ago
| Makefile | ||
|---|---|---|
| 170 | 170 |
db: schemas/vegbien.sql _always |
| 171 | 171 |
-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin) |
| 172 | 172 |
-echo "CREATE DATABASE vegbien OWNER bien ENCODING 'UTF8' \ |
| 173 |
TEMPLATE template1;"|$(psqlAsAdmin)
|
|
| 174 |
$(psqlAsBien) <$<
|
|
| 173 |
TEMPLATE template0;"|$(psqlAsAdmin)
|
|
| 174 |
<$< bin/db_dump_localize|$(psqlAsBien)
|
|
| 175 | 175 |
# ignore errors if user or database exists |
| 176 | 176 |
|
| 177 | 177 |
confirmRmDb = $(call confirm,WARNING: This will delete your VegBIEN DB!\ |
Also available in: Unified diff
main Makefile: VegBIEN DB: db: Use template0 to allow encodings other than UTF-8. Because template0 doesn't have plpgsql on PostgreSQL before 9.x, add "CREATE PROCEDURAL LANGUAGE plpgsql;" manually in schemas/vegbien.sql.make, and filter it back out on PostgreSQL after 9.x using db_dump_localize.