Обсуждение: pg_dump question

Поиск
Список
Период
Сортировка

pg_dump question

От
Carol Walter
Дата:
Hello-

I'm trying to do an upgrade of version 8.1 to 8.2.3.  The restore is
failing because of some code that is in some views.  If I dump the
just the schema and then dump just the data, will the views be included?

Carol

Re: pg_dump question

От
"Scott Marlowe"
Дата:
On Dec 7, 2007 2:18 PM, Carol Walter <walterc@indiana.edu> wrote:
> Hello-
>
> I'm trying to do an upgrade of version 8.1 to 8.2.3.  The restore is
> failing because of some code that is in some views.  If I dump the
> just the schema and then dump just the data, will the views be included?

Well, that really kinda depends.

Are you pg_dumping with 8.2's pg_dump?  If not try that.

What exact error messages are you getting?