Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

As a PostgreSQL fan myself, the main thing I miss in PostgreSQL (as opposed to DB2 or Oracle) is nice and simple hot backups with point-in-time recovery. It is certainly possible but (at least in 9.0) it requires a non-trivial level of understanding of the WAL archiving process to set it up and run it smoothly and safely. Given how important backups are, I still tend to stay away from messing with WAL logs and just use SQL dumps (pg_dump) for backups for the time being. I really miss the simplicity of dealing with transaction logs and roll forwarding in DB2.


If you read the release notes I believe the new pg_basebackup tool satisfies your needs.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: