pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (4+ messages)

Message-ID: <26528.1122942927@sss.pgh.pa.us>
Permalink:  ../26528.1122942927@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/26528.1122942927@sss.pgh.pa.us

 · 

reply

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