r/programming • u/squareproton • Nov 16 '14
PostgreSQL vs. MS SQL Server - A comparison of two relational databases from the point of view of a data analyst
http://www.pg-versus-ms.com/
171
Upvotes
r/programming • u/squareproton • Nov 16 '14
2
u/sgoody Nov 20 '14
I'm sure the last time I remember reading the documentation that if you wanted to recover a database to a point in time you had to shutdown the PostgreSQL service, do some file copies/deletes for data files and then start the service back up, at which point you get a point in time for all databases.
If that is the case, then this seems a bit limiting to me that you have to A) stop the world B) restore every database or nothing
Of course this is only what I have read and may be either incorrect or out of date.