Re: pg_dump failure in tar format.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump failure in tar format.
Дата
Msg-id 26528.1122942927@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump failure in tar format.  ("Tomeh, Husam" <htomeh@firstam.com>)
Список pgsql-admin
"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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: pg_dump failure in tar format.
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: some databases have not been vacuumed ...