diff options
Diffstat (limited to 'content/blog/miscellaneous')
| -rw-r--r-- | content/blog/miscellaneous/pleroma.md | 7 | ||||
| -rw-r--r-- | content/blog/miscellaneous/postgresql-reassign.md | 2 |
2 files changed, 5 insertions, 4 deletions
diff --git a/content/blog/miscellaneous/pleroma.md b/content/blog/miscellaneous/pleroma.md index 28ac365..725541a 100644 --- a/content/blog/miscellaneous/pleroma.md +++ b/content/blog/miscellaneous/pleroma.md @@ -13,7 +13,8 @@ This article is about my installation of pleroma in a standard alpine linux lxd ## Installation notes {{< highlight sh >}} -apk add elixir nginx postgresql postgresql-contrib git sudo erlang-ssl erlang-xmerl erlang-parsetools erlang-runtime-tools make gcc build-base vim vimdiff htop curl +apk add elixir nginx postgresql postgresql-contrib git sudo erlang-ssl erlang-xmerl erlang-parsetools \ + erlang-runtime-tools make gcc build-base vim vimdiff htop curl /etc/init.d/postgresql start rc-update add postgresql default cd /srv @@ -49,10 +50,10 @@ curl http://localhost:4000/api/v1/instance If this works, you can shut it down with two C-c and we can configure nginx. This article doesn't really cover my setup since my nginx doesn't run there, and I am using letsencrypt wildcard certificates fetched somewhere else unrelated, so to simplify I only paste the vhost part of the configuration : {{< highlight sh >}} - ### in nginx.conf inside the container ### # {{{ pleroma -proxy_cache_path /tmp/pleroma-media-cache levels=1:2 keys_zone=pleroma_media_cache:10m max_size=500m inactive=200m use_temp_path=off; +proxy_cache_path /tmp/pleroma-media-cache levels=1:2 keys_zone=pleroma_media_cache:10m max_size=500m + inactive=200m use_temp_path=off; ssl_session_cache shared:ssl_session_cache:10m; server { listen 80; diff --git a/content/blog/miscellaneous/postgresql-reassign.md b/content/blog/miscellaneous/postgresql-reassign.md index b794442..d7d28d9 100644 --- a/content/blog/miscellaneous/postgresql-reassign.md +++ b/content/blog/miscellaneous/postgresql-reassign.md @@ -11,7 +11,7 @@ tags: Here is the sequence of commande that will change the owner of all objects in a database from a user named "support" to another named "test-support": {{< highlight sh >}} ALTER DATABASE name OWNER TO new_owner -for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" YOUR_DB` ; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done +for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" YOUR_DB` ; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" YOUR_DB` ; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" YOUR_DB` ; do psql -c "alter table $tbl owner to NEW_OWNER" YOUR_DB ; done {{< /highlight >}} |