Re: Migrating from 8.3 to 8.4 on the same server

Поиск
Список
Период
Сортировка
От Lewis Kapell
Тема Re: Migrating from 8.3 to 8.4 on the same server
Дата
Msg-id 4BC7167E.2080504@setonhome.org
обсуждение исходный текст
Ответ на Re: Migrating from 8.3 to 8.4 on the same server  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Migrating from 8.3 to 8.4 on the same server  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-admin
On 4/14/2010 5:11 PM, Greg Sabino Mullane wrote:
> If it wouldn't kill you, I'd suck up the time. All other solutions
> are going to take additional expertise, prep, and testing.
>
> Keep in mind that if you have tables and/or databases that don't
> change frequently, you can dump those beforehand to minimize
> the final downtime.

That's true, I had thought about that also.  I guess I would save the
contents of the biggest tables to flat files using the COPY command,
then delete the copied rows, before doing the dump.  Is what what you
had in mind?

Lewis


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

Предыдущее
От: "Thorne, Francis"
Дата:
Сообщение: AIX Postgres Compile Error
Следующее
От: Lewis Kapell
Дата:
Сообщение: Re: Query is stuck