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
