Search Postgresql Archives

Re: errors on restoring postgresql binary dump to glusterfs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, May 7, 2012 at 5:02 PM, Liang Ma <ma.satops@xxxxxxxxx> wrote:
> On Fri, May 4, 2012 at 3:58 AM, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote:
>> On Mon, Apr 30, 2012 at 8:34 PM, Liang Ma <ma.satops@xxxxxxxxx> wrote:
>>> Hi There,
>>>
>>> While trying to restore a ~700GM binary dump by command
>>>
>>> pg_restore -d dbdata < sampledbdata-20120327.pgdump
>>>
>>> I encountered following errors repeatedly
>>>
>>> pg_restore: [archiver (db)] Error from TOC entry 2882463; 2613
>>> 10267347 BLOB 10267347 sdmcleod
>>> pg_restore: [archiver (db)] could not execute query: ERROR:
>>> unexpected data beyond EOF in block 500 of relation base/16386/11743
>>> HINT:  This has been seen to occur with buggy kernels; consider
>>> updating your system.
>>
>> Note the message right here...
>>
>> There may be further indications in the server log about what's wrong.
>>
>
> The server's logs in message file were clean.

Then your logging is incorrectly configured, because it should *at
least* have the same message as the one that showed up in the client.


>>> The server runs Ubuntu server 10.04 LTS with postgresql upgraded to
>>> version 9.1.3-1~lucid. The postgresql data directory is located in a
>>> glusterfs mounted directory to a replicated volume vol-2
>>
>> I assume you don't have more than one node actually *accessing* the
>> data directory at the same time, right?
>>
>
> Yes, you are right. I just set up this glusterfs and postgresql server
> with two nodes for testing purpose. There was no other gluster
> filesystem access activity at the time I tried to restore the
> postgresql dump. Do you know if postgresql recommends any other
> cluster filesystem, or it may not like cluster filesystem at all?


Did you have PostgreSQL started on both nodes? That is *not*
supported. If PostgreSQL only runs on one node at a time it should in
theory work, provided the cluster filesystem provides all the services
that a normal filesystem does, such as respecting fsync.

-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux