Различия
Показаны различия между двумя версиями страницы.
| sw:openhab:faq:postgresql [2023/12/22 15:30] – создано lazygatto | sw:openhab:faq:postgresql [2023/12/22 15:32] (текущий) – lazygatto | ||
|---|---|---|---|
| Строка 9: | Строка 9: | ||
| Add user for openhab | Add user for openhab | ||
| <sxh> | <sxh> | ||
| - | sudo su postgres | + | > sudo su postgres |
| - | createuser openhab -P --interactive | + | > createuser openhab -P --interactive |
| Enter password for new role: | Enter password for new role: | ||
| Enter it again: | Enter it again: | ||
| Shall the new role be a superuser? (y/n) y | Shall the new role be a superuser? (y/n) y | ||
| + | </ | ||
| + | Create DB | ||
| + | <sxh> | ||
| + | > psql | ||
| + | psql (13.13 (Debian 13.13-0+deb11u1)) | ||
| + | Type " | ||
| + | |||
| + | postgres=# CREATE DATABASE openhab; | ||
| + | CREATE DATABASE | ||
| + | postgres=# exit | ||
| </ | </ | ||