Diskuse:155UZPD Úvod do zpracování prostorových dat: Porovnání verzí
m (→TODO) |
m (→TODO) |
||
Řádek 4: | Řádek 4: | ||
* qgis - segfault | * qgis - segfault | ||
* databaze - pgis_student -> vlastni schema | * databaze - pgis_student -> vlastni schema | ||
== PostGIS == | |||
createuser -D -R -S -P <user> | |||
CREATE SCHEMA <user>; | |||
ALTER SCHEMA b11 OWNER TO <user>; | |||
GRANT ALL ON geometry_columns TO <user>; | |||
GRANT SELECT ON spatial_ref_sys TO <user>; | |||
<source lang=bash> | |||
#!/bin/sh | |||
if [ -z $1 ] ; then | |||
echo "usage: $0 <user>" | |||
exit 1 | |||
fi | |||
USER="$1" | |||
SCHEMA=`echo $USER | cut -d'_' -f2` | |||
DB=pgis_uzpd | |||
createuser -D -R -S -P $1 | |||
psql $DB -c "CREATE SCHEMA $SCHEMA;" | |||
psql $DB -c "ALTER SCHEMA $SCHEMA OWNER TO $USER;" | |||
psql $DB -c "GRANT ALL ON geometry_columns TO $USER;" | |||
psql $DB -c "GRANT SELECT ON spatial_ref_sys TO $USER;" | |||
exit 0 | |||
</source> |
Verze z 30. 3. 2011, 22:37
TODO
- databaze pgis_uzpd_2011
- qgis - segfault
- databaze - pgis_student -> vlastni schema
PostGIS
createuser -D -R -S -P <user>
CREATE SCHEMA <user>; ALTER SCHEMA b11 OWNER TO <user>; GRANT ALL ON geometry_columns TO <user>; GRANT SELECT ON spatial_ref_sys TO <user>;
#!/bin/sh
if [ -z $1 ] ; then
echo "usage: $0 <user>"
exit 1
fi
USER="$1"
SCHEMA=`echo $USER | cut -d'_' -f2`
DB=pgis_uzpd
createuser -D -R -S -P $1
psql $DB -c "CREATE SCHEMA $SCHEMA;"
psql $DB -c "ALTER SCHEMA $SCHEMA OWNER TO $USER;"
psql $DB -c "GRANT ALL ON geometry_columns TO $USER;"
psql $DB -c "GRANT SELECT ON spatial_ref_sys TO $USER;"
exit 0