...
| Code Block |
|---|
$ sudo -u postgres psql -c "create database webclient;" $ sudo -u postgres psql -c "create user webclient;" $ sudo -u postgres psql -c "alter user webclient with encrypted password 'webclient';" $ sudo -u postgres psql -c "grant all privileges on database webclient to webclient;" |
For Postgres 15 and newer here are additional steps:
| Code Block |
|---|
GRANT ALL PRIVILEGES ON DATABASE webclient TO webclient;
\c webclient postgres
# You are now connected to database "webclient" as user "postgres".
GRANT ALL ON SCHEMA public TO webclient; |
Install nginx
| Code Block |
|---|
$ sudo apt-get install nginx |
...