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 0B4975280D for ; Sat, 25 Jun 2005 14:08:50 -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 44996-07 for ; Sat, 25 Jun 2005 17:08:44 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 09BAC52831 for ; Sat, 25 Jun 2005 14:08:43 -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 j5PH8gCk027952; Sat, 25 Jun 2005 13:08:42 -0400 (EDT) To: Alberto Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump -Fc does not dump indexes] In-reply-to: <42BD7E72.3050201@freenet.de> References: <42BD7E72.3050201@freenet.de> Comments: In-reply-to Alberto message dated "Sat, 25 Jun 2005 08:55:30 -0700" Date: Sat, 25 Jun 2005 13:08:42 -0400 Message-ID: <27951.1119719322@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/213 X-Sequence-Number: 17968 Alberto writes: > 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