I'm running the following command to create a dump of all database on my production server: prodserver:/# pg_dumpall -U postgres -h 184.108.40.206 > prod.sql on my development box, I also take a ...
I’m trying to set up backup strategy for a production postgreSQL DB. It will have large amount of data and it should be running 24 X 7. Could you recommend some backup & recovery strategies that ...
I'm reading http://www.postgresql.org/docs/9.2/static/pgarchivecleanup.html and to me it seems like it will remove any and all WAL segments from my slave server that aren't required to perform ...