| From: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help - corruption issue? |
| Date: | 2011-04-26 18:40:04 |
| Message-ID: | 4DB71184.6060403@fuzzy.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dne 26.4.2011 14:41, Phoenix Kiula napsal(a):
> On Tue, Apr 26, 2011 at 3:24 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> Are you sure you're getting all the data out of the source (broken)
>> database you think you are? Are you sure those rows are in the dump?
>
>
>
> Actually I am not. Some rows are missing.
>
> Will a COUNT(*) on the two databases -- old and new -- be sufficient
> and reliable information about the number of rows that went AWOL?
That should give us at least some idea if the copy worked. Have you
checked the postmaster.log (and kernel log in /var/log/messages) why the
new DB crashed when you do "SELECT * FROM mytable LIMIT 1" (as TL
recommended yesterday)?
Tomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2011-04-26 18:56:10 | Partial Index [WHERE col IN ('A','B')] Planner Anomalies |
| Previous Message | Tomas Vondra | 2011-04-26 18:36:54 | Re: Help - corruption issue? |