comparison: davical/davical-setup.sh
davical/davical-setup.sh
- changeset 298
- e2eb036d448f
- parent 295
- adc4bc1f8985
- child 396
- 610cba0674b9
equal
deleted
inserted
replaced
| 1:b7e842bca9b2 | 2:71cefb3e8116 |
|---|---|
| 38 fi | 38 fi |
| 39 | 39 |
| 40 # create database | 40 # create database |
| 41 ( echo "CREATE ROLE $db_user LOGIN ENCRYPTED PASSWORD '$db_pass' NOCREATEDB NOCREATEUSER;" | 41 ( echo "CREATE ROLE $db_user LOGIN ENCRYPTED PASSWORD '$db_pass' NOCREATEDB NOCREATEUSER;" |
| 42 echo "CREATE TABLESPACE $db_name OWNER $db_user LOCATION '$db_dir';" | 42 echo "CREATE TABLESPACE $db_name OWNER $db_user LOCATION '$db_dir';" |
| 43 echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE $db_name ENCODING 'UTF8';" | 43 echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE $db_name ENCODING 'SQL_ASCII';" |
| 44 ) | PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" -d "$db_sname" -f- | 44 ) | PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" -d "$db_sname" -f- |
| 45 PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" \ | 45 PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d "$db_name" \ |
| 46 -c "CREATE LANGUAGE plpgsql;" | 46 -c "CREATE LANGUAGE plpgsql;" |
| 47 | 47 |
| 48 # create schema 1/2 (from original "create_database" script) | 48 # create schema 1/2 (from original "create_database" script) |
