| From: | David Steele <david(at)pgmasters(dot)net> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br> |
| Cc: | Martin Marques <martin(dot)marques(at)2ndquadrant(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Does PostgreSQL check database integrity at startup? |
| Date: | 2017-12-26 21:42:38 |
| Message-ID: | 3e608a5a-108f-38ad-291c-85447dd9a349@pgmasters.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/26/17 10:57 AM, Pavel Stehule wrote:
> 2017-12-26 16:50 GMT+01:00 Edson Carlos Ericksson Richter
>>
> I'm rebuilding the standby server for two days already, with 23% of
> completion status...
> If lost the database and backups because of that failure, it would
> be a giant disaster.
> Few hours checking integrity would be acceptable... Specially if I
> can run it on standby only.
>
>
> very simple check
>
> pgdumpall > /dev/null
>
> but this doesn't check indexes.
pgBackRest will validate all page checksums (including indexes, etc.) in
the cluster during backup. Full backups check everything,
incr/differential backups check only the files that have changed.
--
-David
david(at)pgmasters(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-12-26 21:58:47 | Re: Does PostgreSQL check database integrity at startup? |
| Previous Message | Edson Carlos Ericksson Richter | 2017-12-26 17:46:26 | Re: Does PostgreSQL check database integrity at startup? |