Bump

4 files changed, 52 insertions, 0 deletions

diff --git a/content/en/blog/kubernetes/_index.md b/content/en/blog/kubernetes/_index.md
new file mode 100644
index 0000000..3545b68
--- /dev/null
+++ b/content/en/blog/kubernetes/_index.md
@@ -0,0 +1,5 @@
+---
+title: "Kubernetes"
+linkTitle: "Kubernetes"
+weight: 40
+---
diff --git a/content/en/blog/kubernetes/pg_dump_restore.md b/content/en/blog/kubernetes/pg_dump_restore.md
new file mode 100644
index 0000000..9aafb63
--- /dev/null
+++ b/content/en/blog/kubernetes/pg_dump_restore.md
@@ -0,0 +1,24 @@
+---
+title: "Dump and restore a postgresql database on kubernetes"
+linkTitle: "Dump and restore a postgresql database"
+date: 2020-06-25
+---
+
+## Dumping
+Assuming we are working with a postgresql statefulset, our namespace is named `miniflux` and our master pod is named `db-postgresql-0`, trying to
+dump a database named `miniflux`:
+{{< highlight sh >}}
+export POSTGRES_PASSWORD=$(kubectl get secret --namespace miniflux db-postgresql -o jsonpath="{.data.postgresql-password}" | base64 --decode)
+kubectl run db-postgresql-client --rm --tty -i --restart='Never' --namespace miniflux --image docker.io/bitnami/postgresql:11.8.0-debian-10-r19 --env="PGPASSWORD=$POSTGRES_PASSWORD" --command -- pg_dump --host db-postgresql -U postgres -d miniflux > miniflux.sql-2020062501
+{{< /highlight >}}
+
+## Restoring
+
+Assuming we are working with a postgresql statefulset, our namespace is named `miniflux` and our master pod is named `db-postgresql-0`, trying to
+restore a database named `miniflux`:
+{{< highlight sh >}}
+kubectl -n miniflux cp miniflux.sql-2020062501 db-postgresql-0:/tmp/miniflux.sql
+kubectl -n miniflux exec -ti db-postgresql-0 -- psql -U postgres -d miniflux
+miniflux=# \i /tmp/miniflux.sql
+kubectl -n miniflux exec -ti db-postgresql-0 -- rm /tmp/miniflux.sql
+{{< /highlight >}}
diff --git a/content/en/blog/miscellaneous/osm-overlay-example.md b/content/en/blog/miscellaneous/osm-overlay-example.md
new file mode 100644
index 0000000..2787a6e
--- /dev/null
+++ b/content/en/blog/miscellaneous/osm-overlay-example.md
@@ -0,0 +1,19 @@
+---
+title: "OpenStreetMap overlay example"
+linkTitle: "OpenStreetMap overlay example"
+date: 2020-05-19
+description: >
+  An example of how to query things visually on OpenStreetMap
+---
+
+http://overpass-turbo.eu/
+{{< highlight html >}}
+<osm-script>
+  <query type="node">
+    <has-kv k="amenity" v="recycling"/>
+    <bbox-query {{bbox}}/>
+  </query>
+  <!-- print results -->
+  <print mode="body"/>
+</osm-script>
+{{< /highlight >}}
diff --git a/content/en/blog/miscellaneous/switching-to-hugo.md b/content/en/blog/miscellaneous/switching-to-hugo.md
index 1bb0c43..7468667 100644
--- a/content/en/blog/miscellaneous/switching-to-hugo.md
+++ b/content/en/blog/miscellaneous/switching-to-hugo.md
@@ -5,3 +5,7 @@ date: 2019-12-19
 description: >
   I switched my personal wiki from dokuwiki to Hugo
 ---
+
+This is the website you are currently reading. It is a static website built using hugo. This article details how I installed hugo, how I initialised this website and how I manage it. I often refer to it as wiki.adyxax.org because I hosted a unique dokuwiki for a long time as my main website (and a pmwiki before that), but with hugo it has become more than that. It is now a mix of wiki, blog and showcase of my work and interests.
+
+[Here is the link to the full article describing how I achieved that.]({{< relref "/docs/adyxax.org/services/www.md" >}})