---
title: "Discussion on \"Dumping and restoring PostgreSQL databases: a personal cheat sheet\" | Hashnode"
description: "Discussion on \"Dumping and restoring PostgreSQL databases: a personal cheat sheet\". 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..."
url: "https://hashnode.com/posts/dumping-and-restoring-pg-dbs-cheat-sheet/6411959e31e089ae539733e0"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [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...

Mar 15, 2023 · 5 min read · fearless.engineering  
Read the article

-   [#databases](https://hashnode.com/tag/databases)
-   [#cheatsheet](https://hashnode.com/tag/cheatsheet)

## Written by

[Andrea Rota](https://hashnode.com/@hotzeplotz)

@hotzeplotz

  
[View profile](https://hashnode.com/@hotzeplotz)

slowly crafting the final 20%

## Responses

Comments are turned off for this post.
