| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Tomeh, Husam" <htomeh(at)firstam(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_dump failure in tar format. |
| Date: | 2005-08-02 00:35:27 |
| Message-ID: | 26528.1122942927@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Tomeh, Husam" <htomeh(at)firstam(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2005-08-02 14:28:52 | Re: some databases have not been vacuumed ... |
| Previous Message | Tomeh, Husam | 2005-08-02 00:23:01 | Re: pg_dump failure in tar format. |