Re: [GENERAL] migration from PointBase to PostgreSQL

2010-10-07 Thread Craig Ringer
On 8/10/2010 12:35 AM, Frank Zhao wrote: We are supposed to migrate PointBase to PostgreSQL. Do you have any advice on how we should approach this, and how to do estimation on the workload? The current PointBase is running on Hub and Spoke by using UniSync for backup and restore purposes. Is th

Re: [GENERAL] migration from PointBase to PostgreSQL

2010-10-07 Thread Rob Sargent
1. get an ascii dump of the source database. 2. check if for consistency if you're ambitious or suspicion by nature (or you've been through this a number of times before and discovered that this is _always_ necessary) 3. create the target database/schema 4. convert source data to target as per