view flys-backend/README @ 1240:2ef8b67bd68a

Replaced SERIALs with SEQUENCES in PostgreSQL spatial schema. flys-backend/trunk@2642 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 02 Sep 2011 13:49:46 +0000
parents 324e12ab7a05
children 90142c839fe5
line wrap: on
line source
For the artifact database
# su - postgres
$ createuser --no-createrole --no-superuser --pwprompt --no-createdb artifacts
$ createdb --encoding=UTF-8 --owner artifacts artifactsdb

For the flys database

# su - postgres
$ createuser --no-createrole --no-superuser --pwprompt --no-createdb flys
$ createdb --encoding=UTF-8 --owner flys flystest1

http://dive4elements.wald.intevation.org