You can create a database using the pgAdmin tool or Command Prompt.
The created database must have onlyoffice both for user and password.
"%ProgramFiles%\PostgreSQL\9.6\pgAdmin 4\bin\pgAdmin4.exe" executable file.
In the pgAdmin window, connect to the PostgreSQL server and create a new login role named
onlyoffice with the
onlyoffice password. To do that perform the following steps:
- Right-click on the Login/Group Roles item in the left-side menu and select Create -> Login/Group Role.
- In a new window that opens enter
onlyoffice in the Name field.
- Switch to the Definition tab and enter
onlyoffice in the Password field.
- Go to the Privileges tab and click on the Can login? switcher to set the Yes value.
- Click the Save button.
onlyoffice database, choosing the created login role
onlyoffice as an owner.
To do that, right-click on the Databases item in the left-side menu, select Create -> Database.... In a new window that opens enter
onlyoffice in the Database field and select the
onlyoffice role in the Owner list, then click Save.
Run the Command Prompt (press the
win+r key combination, type in
cmd and press Enter).
Consistently execute the following commands:
cd /D "%ProgramFiles%\PostgreSQL\9.6\bin"
psql -U postgres -c "CREATE DATABASE onlyoffice;"
psql -U postgres -c "CREATE USER onlyoffice WITH password 'onlyoffice';"
psql -U postgres -c "GRANT ALL privileges ON DATABASE onlyoffice TO onlyoffice;"