We use both Oracle and PostgreSQL in my company.
When asked by non-technical bosses about the differences between PostgreSQL and Oracle, I reply that one of the main advantages of Oracle is its point-in-time recovery.
This means: With Oracle, if you make a full backup on 8:00 am, and on 3:00 pm the database crashed and the data files were ruined but the log files and the backup files are intact, you could restore the database up to the last transaction that was commited before the database crashed. This could be up to 2:59:59 pm. With PostgreSQL, you can restore only up to 8:00 am.
Now I'm wondering: Is it true that PostgreSQL has no point-in-time recovery? Because if it has, we'll seriously consider going 100% Postgres.
