From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomeh, Husam <htomeh@firstam.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump failure in tar format.
Date: Mon, 01 Aug 2005 20:35:27 -0400
Message-ID: <26528.1122942927@sss.pgh.pa.us> (raw)
In-Reply-To: <C45835824D00A844BBD0F032D5CDED920116DC31@pisgana01sxch01.ana.firstamdata.com>
References: <C45835824D00A844BBD0F032D5CDED920116DC31@pisgana01sxch01.ana.firstamdata.com>
"Tomeh, Husam" <htomeh@firstam.com> writes:
> I was told that because the data is on postgres 8.0 and I'm trying to
> restore on another database which 7.3 that I can not do that. However,
> researching more, I could not find a proof to what I was told, So, I
> will try to use -Fc instead. Do you agree that I can restore with -Fc
> regardless of the different versions of the databases?
You're very likely going to have some issues with SQL command syntax,
but I don't believe that using -Ft instead of -Fc would help on that.
My recommendation is to try a schema-only dump (-s option) and make sure
you can load that, before you spend time making and loading a full dump.
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: tgl@sss.pgh.pa.us, htomeh@firstam.com
Subject: Re: pg_dump failure in tar format.
In-Reply-To: <26528.1122942927@sss.pgh.pa.us>
References: <C45835824D00A844BBD0F032D5CDED920116DC31@pisgana01sxch01.ana.firstamdata.com> <26528.1122942927@sss.pgh.pa.us>
* 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