comparison: setup/postgres/psql_create_database.sql
setup/postgres/psql_create_database.sql
- changeset 16
- 4e0998805276
- parent 5
- 131903fc16b8
equal
deleted
inserted
replaced
| 15:bb594abac796 | 16:4e0998805276 |
|---|---|
| 1 -- Create a database owner role, which has no login permissions. | 1 -- Create a database owner role, which is also a privileged user |
| 2 -- You can either: | 2 create user lightpit_dbo with password 'lpit_dbo_changeme'; |
| 3 -- 1) login as default user and switch the user | |
| 4 -- 2) decide to override this decision and give login permissions | |
| 5 -- 3) use your superuser of choice to manage the database (not recommended!) | |
| 6 create role lightpit_dbo with password 'lpit_dbo_changeme'; | |
| 7 | 3 |
| 8 -- Create the actual (unprivileged) database user | 4 -- Create the actual (unprivileged) database user |
| 9 create user lightpit_user with password 'lpit_user_changeme'; | 5 create user lightpit_user with password 'lpit_user_changeme'; |
| 10 | 6 |
| 11 -- Create the LightPIT schema | 7 -- Create the LightPIT schema |
