Re: WAL segments (names) not in a sequence

Поиск
Список
Период
Сортировка
От German Becker
Тема Re: WAL segments (names) not in a sequence
Дата
Msg-id CALyjCLswNyS4qjBxVNugQaGQvVxcAGOZrYdaNgscJ2HJJS15Qg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WAL segments (names) not in a sequence  (Sergey Konoplev <gray.ru@gmail.com>)
Ответы Re: WAL segments (names) not in a sequence
Список pgsql-hackers
Дерево обсуждения
Hi Sergey,

Maybe I didn't explain correctly. I am using COPY/pg_dump/pg_restore for migration (and it is working fine). The streaming replication is for hot-standby replication *once migrated*. Thing is I disbable archving and set wal_level to minimal, when migrating the large portion of data, to make it faster. Then I switch to wal_level=hot_standby, i.e the "production" configuration, and the WAL segment seuqence seems to overlap with the segments generated with the other setting.


On Thu, May 23, 2013 at 7:44 PM, Sergey Konoplev <gray.ru@gmail.com> wrote:
On Thu, May 23, 2013 at 6:18 AM, German Becker <german.becker@gmail.com> wrote:
> Let me describe the process I follow to get to this. What I am doing is
> testing a migration from 8.3 to 9.1. They way I plan to do it is the
> following.
> 1) Create the schema
> 2) import the biggest tables, which are not updated,only growing, with COPY
> (this is about 35gb of data)
> 2)import the small, changing part of the data
>
>
> The target system is 9.1 with streaming relication.
> For steps 1 and 2, I set a "restore" configuration, that amongs other things
> like more work mem, it sets archive_mode=off and wal_level=minimal (attached
> the difference between restore and normal).
> The archive_command is just a cp wrapped in a shell script in case I need to
> change it.

You can not migrate between any major versions with WAL based or
streaming replication.

Use either full dump/restore or schema only dump/restore plus trigger
based replication (londiste, slony) to migrate data.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray.ru@gmail.com

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Removal of pageinspect--1.0.sql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Patch to .gitignore