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 8DA0C52818 for ; Sat, 25 Jun 2005 17:39:19 -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 79838-10 for ; Sat, 25 Jun 2005 20:39:14 +0000 (GMT) Received: from mout0.freenet.de (mout0.freenet.de [194.97.50.131]) by svr1.postgresql.org (Postfix) with ESMTP id 698A15280C for ; Sat, 25 Jun 2005 17:39:09 -0300 (ADT) Received: from [194.97.55.190] (helo=mx6.freenet.de) by mout0.freenet.de with esmtpa (Exim 4.52) id 1DmHQl-0002in-32 for pgsql-admin@postgresql.org; Sat, 25 Jun 2005 22:39:11 +0200 Received: from ip68-6-204-101.sd.sd.cox.net ([68.6.204.101] helo=[192.168.1.147]) by mx6.freenet.de with esmtpsa (ID nspmma@freenet.de) (TLSv1:AES256-SHA:256) (Exim 4.52 #6) id 1DmHQk-0000Ri-LV for pgsql-admin@postgresql.org; Sat, 25 Jun 2005 22:39:10 +0200 Message-ID: <42BDC10D.80301@freenet.de> Date: Sat, 25 Jun 2005 13:39:41 -0700 From: Alberto User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: pg_dump -Fc does not dump indexes References: <42BCC950.5090006@freenet.de> In-Reply-To: <42BCC950.5090006@freenet.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.262 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/216 X-Sequence-Number: 17971 Hi Tom, thanks for answering so quickly! The error occurs for me using pg_dump and pg_restore on postgres 8.0.3 running on RedHat ES4. But also occurs if I take the dump from the Linux box and run restore on a winxp box with postgres 8.0.2. 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? Is there a way for me to find out if the dump file created with -Fc does contain information on the indexes? Thanks, Alberto >> I have tried to backup my postgres database with >> pg_dump -Fc $db > ~/backups/$db.backup.c >> and restore it with: >> createdb -U postgres -D aestel_admin -T template0 restoreTMP >> pg_restore -d restoreTMP -U postgres $db.backup.c >> I do not get any error messages but none of my indexes are created. >Works for me ... can you create a self-contained test case? What PG >version are you using, anyway (and are you sure the pg_dump and >pg_restore programs are of the same version)? > regards, tom lane