| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Karthik Iyer <karthik(dot)i(at)directi(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Cc: | KiritSinh <kirit(dot)p(at)directi(dot)com> |
| Subject: | Re: DATA corruption after promoting slave to master |
| Date: | 2014-06-26 16:07:32 |
| Message-ID: | 53AC4544.2000108@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 06/26/2014 10:34 AM, Karthik Iyer wrote:
> Any inputs here? You think a pgdump and restore would help more ?
A full dump and restore would definitely help. I tend not to suggest
that often because I work with very large databases that are usually
extremely cumbersome to dump and restore.
But yeah, if you can get a successful pg_dump from your database, a
restore should obviously clean up all of your data and index
inconsistencies if you're willing to wait.
--
Shaun Thomas
OptionsHouse, LLC | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2014-06-26 16:26:15 | Re: Function Syntax Help |
| Previous Message | Shaun Thomas | 2014-06-26 16:05:47 | Re: Fast data, slow data |