X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 608279DC9E9 for ; Fri, 24 Mar 2006 04:03:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44825-06 for ; Fri, 24 Mar 2006 04:03:32 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 4FE049DC804 for ; Fri, 24 Mar 2006 04:03:30 -0400 (AST) Received: from mail.globonet.hu (mail.globonet.hu [82.144.160.194]) by svr4.postgresql.org (Postfix) with ESMTP id B4BEB5AF027 for ; Fri, 24 Mar 2006 08:03:31 +0000 (GMT) Received: from mail.globonet.hu (host-170-10.globonet.hu [82.144.170.10]) by mail.globonet.hu (8.12.11/8.12.10) with SMTP id k2O83R05012393 for ; Fri, 24 Mar 2006 09:03:28 +0100 Received: from 192.168.0.181 ([192.168.0.181]) by mail.globonet.hu (WinRoute Pro 4.1) with SMTP; Fri, 24 Mar 2006 09:03:30 +0100 Date: Fri, 24 Mar 2006 09:03:24 +0100 From: =?ISO-8859-2?Q?R=F3zsahegyi_L=E1szl=F3?= To: pgsql-admin@postgresql.org Subject: Invalid page feader on Solaris 10 Message-Id: <20060324090324.bbc620c2.laszlo.rozsahegyi@rool.hu> Organization: ROOL Informatika Kft. X-Mailer: Sylpheed version 2.2.1 (GTK+ 2.6.10; i686-pc-mingw32) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/230 X-Sequence-Number: 20987 Hi! We have a Sun Fire V480 server 4GB of memory with Solaris 10 operation syst= em and PostgreSQL 8.1.3 (from Sun). The dump of my database is about 2 GB if we are lucky. If not, we have one of error messages: - pg_dump: ERROR: invalid memory alloc request size 2623204397 - pg_dump: ERROR: could not access status of transaction 2423378468 DETAIL: could not open file "pg_clog/0907": No such file or directory - pg_dump: ERROR: invalid page header in block 16147 of relation "jn_szll" What is the problem? Some line of postgresql.conf: (the others are default) shared_buffers =3D 50000 #1000 # min 16 or max_connectio= ns*2, 8KB each #temp_buffers =3D 1000 # min 100, 8KB each #max_prepared_transactions =3D 5 # can be 0 or more # note: increasing max_prepared_transactions costs ~600 bytes of shared mem= ory # per transaction slot, plus lock space (see max_locks_per_transaction). work_mem =3D 81920 #1024 # min 64, size in KB maintenance_work_mem =3D 16384 # min 1024, size in KB #max_stack_depth =3D 2048 # min 100, size in KB # - Free Space Map - max_fsm_pages =3D 80000 #20000 # min max_fsm_relations*1= 6, 6 bytes each max_fsm_relations =3D 4000 #1000 # min 100, ~70 bytes each autovacuum =3D on # enable autovacuum subprocess? autovacuum_naptime =3D 600 # time between autovacuum runs, i= n secs --=20 =DCdv=F6zlettel: R=F3zsahegyi L=E1szl=F3