X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CFAB8D1D707 for ; Sun, 23 Nov 2003 18:49:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 65612-06 for ; Sun, 23 Nov 2003 14:48:46 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id BB799D1D722 for ; Sun, 23 Nov 2003 14:48:44 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hANImf19028538; Sun, 23 Nov 2003 13:48:41 -0500 (EST) To: alvaro@audifarma.com.co Cc: pgsql-admin@postgresql.org Subject: Re: Problem doing pg_dumpall In-reply-to: <46479.200.31.204.249.1069419948.squirrel@audifarm.audifarma.com.co> References: <46479.200.31.204.249.1069419948.squirrel@audifarm.audifarma.com.co> Comments: In-reply-to alvaro@audifarma.com.co message dated "Fri, 21 Nov 2003 08:05:48 -0500" Date: Sun, 23 Nov 2003 13:48:41 -0500 Message-ID: <28537.1069613321@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/390 X-Sequence-Number: 11377 alvaro@audifarma.com.co writes: > # pg_dumpall > data_dump > pg_dump: could not find namespace with OID 102548365 > pg_dumpall: pg_dump failed on dbsa, exiting Hm. It would seem that you have an invalid namespace link in one of the other system catalogs. You could try doing select * from pg_class where relnamespace = 102548365; select * from pg_type where typnamespace = 102548365; select * from pg_proc where pronamespace = 102548365; etc until you find the problem. (Your trace suggests that pg_type is where the problem is, but that's not certain.) Where we go after that depends on what you find. I'd be wondering about whether there is corruption elsewhere in the same catalog ... Also, what PG version is this exactly? regards, tom lane