⇤ ← Revision 1 as of 2007-02-07 14:05:55
1052
Comment:
|
842
|
Deletions are marked like this. | Additions are marked like this. |
Line 20: | Line 20: |
1. sudo -u postgres createdb -O '''USERNAME''' -D user_'''USERNAME''' '''DBNAME'''` ) { 1. $dir = /afs/hcoop.net/common/databases/USERNAME/postgres/'''DBNAME''' 1. chown -R postgres:postgres "$dir" 1. chmod -R 0700 "$dir" 1. fs setacl -dir $dir/'''DBNAME'''/ -acl postgres all |
1. sudo -u postgres createdb -O '''USERNAME''' -D user_'''USERNAME''' '''DBNAME''' |
See MySQL for list of things that have to be done for any database (both MySQL and Postgres).
1. Postgres-specific setup
- $dir = /afs/hcoop.net/common/databases/USERNAME/postgres
If $dir does NOT exist:
sudo -u postgres psql -c "CREATE USER USERNAME" template1
- mkdir -p $dir
- chown postgres:postgres "$dir"
- fs setacl -dir $dir -acl postgres write
- fs setacl -dir $dir -acl databases none # (keep out other databases, just in case)
- fs setacl -dir $dir -acl system:backup rl # (should be inherited from parent dir)
sudo -u postgres psql -c "CREATE TABLESPACE user_USERNAME OWNER USERNAME LOCATION '$dir'" template1
When it does, go directly to database creation step:
sudo -u postgres createdb -O USERNAME -D user_USERNAME DBNAME