---
title: "Andrea Rota (@hotzeplotz) | Hashnode"
description: "slowly crafting the final 20%. Read the latest articles by Andrea Rota on Hashnode."
url: "https://hashnode.com/@hotzeplotz"
---

@hotzeplotz

# Andrea Rota

@hotzeplotz · Joined July 2022

slowly crafting the final 20%

### [Dumping and restoring PostgreSQL databases: a personal cheat sheet](https://fearless.engineering/dumping-and-restoring-pg-dbs-cheat-sheet?utm_source=hashnode&utm_medium=feed)

I occasionally need to dump and restore PostgreSQL databases: infrequently enough that I tend to forget about all the useful CLI switches to the pg\_dump and pg\_restore commands, yet frequently enough that having to look up the manual page for them, a...

5 min read · [fearless.engineering](https://fearless.engineering/dumping-and-restoring-pg-dbs-cheat-sheet?utm_source=hashnode&utm_medium=feed)

[Mar 15, 2023](https://hashnode.com/posts/dumping-and-restoring-pg-dbs-cheat-sheet/6411959e31e089ae539733e0)
