On 12/10/2014 10:08 AM, Gabriel Sánchez Martínez wrote:
>
> On 12/10/2014 01:00 PM, Adrian Klaver wrote:
>> On 12/10/2014 09:54 AM, Gabriel Sánchez Martínez wrote:
>>>
>>> On 12/10/2014 12:47 PM, Adrian Klaver wrote:
>>>> On 12/10/2014 09:25 AM, Gabriel Sánchez Martínez wrote:
>>>>>
>>>>> On 12/10/2014 11:49 AM, Adrian Klaver wrote:
>>>>>> On 12/10/2014 08:31 AM, Gabriel Sánchez Martínez wrote:
>>>>>>>
>>>>>>> On 12/10/2014 11:16 AM, Adrian Klaver wrote:
>>>>>>>> On 12/10/2014 08:07 AM, Gabriel Sánchez Martínez wrote:
>>>>>>>>> Hi all,
>>>>>>>>>
>>
>>>>>>
>>>>>> Also how did the Postgres server get installed?
>>>>>
>>>>> apt-get install
>>>>
>>>> Install from what repo?
>>>
>>> The default Ubuntu repository.
>>>
>>>>
>
>
>
>>
>> The database was
>>> upgraded to 9.3 when Ubuntu was upgraded to 14.04. But I ran it for a
>>> while without issues. This issue is recent.
>>
>> So what was the version before?
>
> 9.1. It has always been whatever was on the Ubuntu repos.
>
>>
>> Where I am going with this, is trying to determine whether you have a
>> 'contaminated' data directory.
>
> I appreciate it! Perhaps it is worth mentioning that the server had
> some issues with the linux md raid a while back. Two disks failed in
> quick succession and some data was corrupted. Those disks have been
> replaced and the RAID has been fine ever since. The database cluster
> was recreated from scratch after that, from backups of a few months
> before the disks started misbehaving. This is when that table was
> created with pg_restore. There were no issues with the restore, and the
> backup was from a few months before the disk issue, so I don't suspect
> corruption in the backup.
I would investigate the possibility that the raid is having problems again.
>
--
Adrian Klaver
adrian.klaver@aklaver.com