Re: pg_upgrade

Поиск
Список
Период
Сортировка
От Tory M Blue
Тема Re: pg_upgrade
Дата
Msg-id CAEaSS0bCNP_+F3CMgLhY9Rmg1d-ikDg0Dj9iuueK3+4QQkkYvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: pg_upgrade
Список pgsql-performance
On Sat, Dec 3, 2011 at 6:04 AM, Bruce Momjian <bruce@momjian.us> wrote:

> Well, I am not totally clear how you are moving things around, but I do
> know pg_upgrade isn't happy to have the old and new cluster be very
> different.
>
> What I think is happening is that you didn't properly move the
> tablespace in the old cluster.  We don't give you a very easy way to do
> that.  You need to not only move the directory, but you need to update
> the symlinks in data/pg_tblspc/, and update the pg_tablespace system
> table.  Did you do all of that?  Does the 8.4 server see the tablespace
> properly after the move, but before pg_upgrade?


Simple answer is umm no..
"http://www.postgresql.org/docs/current/static/pgupgrade.html" is
obviously lacking than :)

Soooo I can take what you have told me and see if I can't attempt to
make those things happen and try again. Makes sense, but boy that's a
large piece of info missing in the document!

Thanks again

Tory

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Question about VACUUM
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Question about VACUUM