Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-setup.sh @ 8796:358a0fd48a00
createlang is deprecated and PL/pgSQL installed by default.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 10 Dec 2015 18:25:11 +0100 |
| parents | c1cea6c95967 |
| children | f89fb9e9abad |
comparison
equal
deleted
inserted
replaced
| 8795:13d5b6c67cef | 8796:358a0fd48a00 |
|---|---|
| 11 # it is assumed that the owner of the DB has the same name as the DB! | 11 # it is assumed that the owner of the DB has the same name as the DB! |
| 12 | 12 |
| 13 # create PostGIS-DB | 13 # create PostGIS-DB |
| 14 createuser -S -D -R $DB_NAME | 14 createuser -S -D -R $DB_NAME |
| 15 createdb $DB_NAME | 15 createdb $DB_NAME |
| 16 createlang plpgsql $DB_NAME | |
| 17 | 16 |
| 18 psql -d $DB_NAME -c "ALTER USER $DB_NAME WITH PASSWORD '$DB_NAME';" | 17 psql -d $DB_NAME -c "ALTER USER $DB_NAME WITH PASSWORD '$DB_NAME';" |
| 19 | 18 |
| 20 psql -d $DB_NAME -c "CREATE EXTENSION postgis;" | 19 psql -d $DB_NAME -c "CREATE EXTENSION postgis;" |
| 21 psql -d $DB_NAME -c "GRANT ALL ON geometry_columns TO $DB_NAME; | 20 psql -d $DB_NAME -c "GRANT ALL ON geometry_columns TO $DB_NAME; |