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