4 ms·
Have you looked at http://www.postgresql.org/docs/9.4/static/app-pgbasebackup.html http://www.postgresql.org/docs/9.4/static/app-pgbasebackup.h...?
by Jweb_Guru 12y ago
Have you looked at http://www.postgresql.org/docs/9.4/static/app-pgbasebackup.html http://www.postgresql.org/docs/9.4/static/app-pgbasebackup.h...?
- ssmoot 12y agoThat's really just for setting up replication IME (and even then, that's pretty complex compared to MSSQL). What if I fat finger a table drop for Client A? With pgbasebackup the best I could do is set up an entirely new server and jump through some hoops. With MSSQL I could just restore the single client database to a new database, very quickly, and SELECT INTO the missing data from clientdb_a_backup to clientdb_a. It's just a lot simpler, a lot quicker, and a lot more flexible.