On Wed, Nov 23, 2016 at 2:12 PM, Gunnar "Nick" Bluth <gunnar.bl...@pro-open.de> wrote: > Am 23.11.2016 um 20:21 schrieb Kevin Grittner: >> On Wed, Nov 23, 2016 at 12:24 PM, Gunnar "Nick" Bluth >> <gunnar.bl...@pro-open.de> wrote:
>>> to get actual _data loss_, you'd have to have a power outage in >>> the DC caused by your PG server exploding... >> If you value the data in your database you should assume that the >> OS could go down at any instant without proper shutdown, and that >> your storage system(s) could be lost without warning at any time. > I've been in this business for 15 years, and had my share of outages. > [enumeration of various failure modes and their respective impacts] I have seen multiple posts on these lists where people say that they don't need to worry about data written to the OS failing to make it to storage because they a really good UPS. It sounds like you understand that, as important as it is to have a UPS, it does not preclude abrupt equipment failure; but I fear that the statement you made might reinforce that notion in some quarters. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
