Re: Multiple versions on same box

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Multiple versions on same box
Дата
Msg-id dcc563d10710090119u78d2e8cx1bdbf33af2a80840@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple versions on same box  (Reece Hart <reece@harts.net>)
Список pgsql-general
Дерево обсуждения
On 10/9/07, Reece Hart <reece@harts.net> wrote:
On Mon, 2007-10-08 at 17:34 -0700, Ralph Smith wrote:
What is the best way to upgrade?  Use pg_dumpall (using 8.2's program), afterwards redirect that file into v8.2 via psql v8.2?

There are lots of ways to do this. My favorite is to bring a new cluster on port 5433 and then pipe data between them, roughly like this:

$ /path/to/7.4/pg_dumpall -p5432 ... | /path/to/8.2/psql -p5433 -qaf- >restore.log 2>&1

Note that when possible you should dump with the pg_dump/pg_dumpall of the version you're going to, in this case 8.2's pg_dumpall

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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Request: Anyone using bogus / "humorous" X-Message-Flag headers, could we please turn them off
Следующее
От: Jan Poslusny
Дата:
Сообщение: foreign keys and memory consumption