3 ms·
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.postg
by Tostino 6y ago
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 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.
- philliphaydon 6y agoI’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.