From: Alberto <nspmma@freenet.de>
To: pgsql-admin@postgresql.org
Subject: Re: pg_dump -Fc does not dump indexes
Date: Sat, 25 Jun 2005 13:39:41 -0700
Message-ID: <42BDC10D.80301@freenet.de> (raw)
In-Reply-To: <42BCC950.5090006@freenet.de>
References: <42BCC950.5090006@freenet.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: nspmma@freenet.de
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>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox