Hacker News new | past | comments | ask | show | jobs | submit login

Yeah, that's because you're using the wrong tool for the job. You are using pg_dump on a single database, or set of databases. Use pg_dumpall: https://www.postgresql.org/docs/current/app-pg-dumpall.html

For an actual backup solution, not one off stuff, use a tool like pgbackrest. It's just way better.

I’m pretty sure I’ve tried dumpall before but honestly cannot remember but you’re right do use dump.

I’ll give dumpall a go today. I do still feel this could be improved in PostgreSQL because there’s sooo many blog posts who suggest dump and none of them work.

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact