Restoring from older pg_dump files

Поиск
Список
Период
Сортировка
От Brooks, Jason
Тема Restoring from older pg_dump files
Дата
Msg-id 796EF5B39103EE45A04CC2FFFCF130B9D80790@ala-mail08.corp.ad.wrs.com
обсуждение исходный текст
Ответы Re: Restoring from older pg_dump files  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Restoring from older pg_dump files  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hello,

I have a data file dumped from a pgsql database version 7.1.2.  I am
having troubles restoring this data to a new database server version
8.1.5.  Are there some gotcha's involved, did the format change, or some
such?

I have used the createdb command to make the basic database.  it's when
I use the \i option in psql that I see invalid commands, syntax errors,
invalid roles, etc.

The original file was created with pg_dump -cou.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jason Brooks ~ (503) 641-3440 x1861
      Direct ~ (503) 924-1861
Email to: jason.brooks@windriver.com
Twiki: http://twiki.wrs.com/do/view/Main/JasonBrooks

Senior Systems Administration Analyst
Wind River Systems
8905 SW Nimbus ~ Suite 255
Beaverton, Or 97008

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Increasing the shared memory
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Restoring from older pg_dump files