Postgres - Ship WAL logs from many servers to one
I have a number of independent postgres servers in my (recently inherited)
environment and I am planning on backing them up via WAL shipping.
I'd like to make one backup server that contains a copy of all of the
databases from each of the production servers. Once I have that, can I
ship WAL logs from all of the production servers to the single backup
server?
If I can get that working, I was then thinking of taking ZFS snapshots
each hour.
Thanks,
-nrb
No comments:
Post a Comment