... | ... | @@ -18,6 +18,25 @@ is like any other Debian machine: |
|
|
This drops you in a [psql shell](https://www.postgresql.org/docs/11/app-psql.html) where you can issue SQL queries
|
|
|
and so on.
|
|
|
|
|
|
## Creating a user and a database
|
|
|
|
|
|
This procedure will create a user and a database named `tor-foo`:
|
|
|
|
|
|
sudo -u postgres createuser -D -E -P -R -S tor-foo
|
|
|
sudo -u postgres createdb tor-foo
|
|
|
|
|
|
For read-only permissions:
|
|
|
|
|
|
sudo -u postgres psql -c 'GRANT SELECT ON ALL TABLES IN SCHEMA public TO tor-foo; \
|
|
|
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO tor-foo; \
|
|
|
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO tor-foo;'
|
|
|
|
|
|
For read-write:
|
|
|
|
|
|
sudo -u postgres psql -c 'GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO tor-foo; \
|
|
|
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO tor-foo; \
|
|
|
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO tor-foo;'
|
|
|
|
|
|
# How-to
|
|
|
|
|
|
## Find what is taking up space
|
... | ... | |