创建新的数据库
| psql -U postgres -c "CREATE DATABASE $DB_NAME;" |
| 1 |
创建新的用户
| psql -U postgres -c "CREATE USER $DB_USER WITH PASSWORD '$DB_PASSWORD';" |
| 1 |
将新数据库的所有权限授予新用户
| psql -U postgres -c "GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $DB_USER;" |
| 1 |
删除数据库
| psql -U postgres -c "DROP DATABASE IF EXISTS $DB_NAME;" |
| 1 |
删除用户
| psql -U postgres -c "DROP USER IF EXISTS $DB_USER;" |
| 1 |
-EOF-
Posted in 就是不分类
Generate your own 90s page here!