So we have a large TB database that we need to migrate to 9.1 and I'm wondering if there's a way to do this process in stages.
Since the date/time storage types changes between 8.3 and 8.4, I realize we'll have to dump the database and my plan is to create a backup using pg_start_backup(), run that backup on another server using postgres 8.3 which I could then dump and import into a 9.1 server. My question is, is there some way I can take WAL files created since the beginning of the original backup on the 8.3 server, convert those into text that I could then apply to the 9.1 server? The mysql equivalent to this is mysqlbinlog which you can apply to mysql binary log files. Cheers, Scott -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
