X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0A05252875 for ; Sat, 25 Jun 2005 18:36:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85700-08 for ; Sat, 25 Jun 2005 21:36:28 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E93A752863 for ; Sat, 25 Jun 2005 18:36:27 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j5PLaRKI029576; Sat, 25 Jun 2005 17:36:27 -0400 (EDT) To: Alberto Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump -Fc does not dump indexes In-reply-to: <42BDC10D.80301@freenet.de> References: <42BCC950.5090006@freenet.de> <42BDC10D.80301@freenet.de> Comments: In-reply-to Alberto message dated "Sat, 25 Jun 2005 13:39:41 -0700" Date: Sat, 25 Jun 2005 17:36:27 -0400 Message-ID: <29575.1119735387@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/218 X-Sequence-Number: 17973 Alberto writes: > I would definetely be willing to create a self contained test case but I > am not sure what that would be. I can create a dump file from a test > database, but that would be after using pg_dump so you could not check > that. Do you want me to create a database, shut it down and zip up the > database files? Which files would those be? Well, basically I want to know how to create a database from which pg_dump can't dump indexes ... can you reconstruct the sequence that got you into this condition? Also ... this is really grasping at straws, but do you have SELinux set in enforcement mode in your RHEL4 system, and if so does changing it to permissive mode make a difference? We've seen a bunch of issues with SELinux :-( --- this does not seem like any of them, but you never know. > Is there a way for me to find out if the dump file created with -Fc does > contain information on the indexes? If "pg_restore -l" shows a lot of stuff but not the indexes (either as indexes or as constraints) then I'd say that's sufficient evidence. regards, tom lane