doubt regarding postgresql backup..
Why can't we run alter commands during pg_dump happening in the database ?
Don't use pg_dump as a backup, it's not what you may think. Use one of the open source tools like pgBackRest or Barman. pg_dump is opening an exclusive transaction that doesn't allow to do any structural changes as that would break the result of pg_dump.
Thank you.... @SneakyPie .. Will check on the mentioned resources...
@SneakyPie Will these tools work with more than 2TB size databases ?
Not only that they work with any size, they are also faster than pg_dump. I personally prefer pgBackRest.
Обсуждают сегодня