point-in-time-recovery Archives - 2ndQuadrant

Posts

Webinar: You forgot to put the WHERE in DELETE? [Follow Up]

December 12, 2019/0 Comments/in Nouman's PlanetPostgreSQL, Webinars /by Nouman

Human oversight is one of the many reasons for compromising a database. Disasters happen, but having a solid backup and disaster recovery plan in place can help your business mitigate such risks. Martín Marqués, Head of Support Operations at 2ndQuadrant, hosted a webinar on backup and disaster recovery options in PostgreSQL. The webinar: “You forgot […]

Evolution of Fault Tolerance in PostgreSQL

July 4, 2016/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

“It is paradoxical, yet true, to say, that the more we know, the more ignorant we become in the absolute sense, for it is only through enlightenment that we become conscious of our limitations. Precisely one of the most gratifying results of intellectual evolution is the continuous opening up of new and greater prospects.” Nikola Tesla […]

How monitoring of WAL archiving improves with PostgreSQL 9.4 and pg_stat_archiver

January 23, 2015/1 Comment/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

PostgreSQL 9.4 introduces a new statistic in the catalogue, called pg_stat_archiver. Thanks to the SQL language it is now possible, in an instant, to check the state of the archiving process of transactional logs (WALs), crucial component of a PostgreSQL disaster recovery system.

Posts

Support & Services

Products

Postgres Learning Center

About Us