streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)

From: Benedikt Grundmann <bgrundmann(at)janestreet(dot)com>
To: PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org>
Subject: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)
Date: 2013-05-14 11:57:10
Message-ID: CADbMkNOL1Hbi4cggF3ZhO68nsr3yRvkunNYz2yBmt8QOupPomw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Today we have seen this on our testing database instance:

ERROR: could not open file "base/16416/291498116.3" (target block 431006):
No such file or directory

That database get's created by rsyncing the LVM snapshot of the standby,
which is a readonly backup of proddb
using streaming replication.

We do not put the standby database into backup mode before rsyncing the LVM
snapshot, trusting postgres ability to recover
from crash. Now we are not sure anymore... Thoughts? It's worth noting
that we have been using this method of taking a backup
for a long long time, but we only recently (after 9.2 came out we switched
to doing a streaming replica and then to take the
"frozen snapshot" backup method from the streaming replica).

Let me know if there is more information you need, or if this is a known
problem.

Thanks,

Bene

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2013-05-14 11:59:23 Re: PostgreSQL 9.3 beta breaks some extensions "make install"
Previous Message Peter Eisentraut 2013-05-14 11:56:00 Re: PostgreSQL 9.3 beta breaks some extensions "make install"