Re: [ADMIN] COPY errors when trying to convert from 7.4.19 to 8.3.1

2008-05-01 Thread Tom Lane
Geoffrey <[EMAIL PROTECTED]> writes: > Shane Ambler wrote: >> You would have two choices - clean up the data in 7.4 before the export >> or clean up after the import and before the fk constraints are added. > The latter is likely the plan. The primary concern is that we don't > lose any data.

Re: [ADMIN] COPY errors when trying to convert from 7.4.19 to 8.3.1

2008-05-01 Thread Geoffrey
Shane Ambler wrote: Geoffrey wrote: We are trying to test our process for upgrading our database from 7.4.19 to 8.3.1. We are following the instructions for dumping the 7.4.19 database from: http://www.postgresql.org/docs/8.3/static/install-upgrading.html ie: /usr/local/pg83/bin/pg_dumpall

Re: [ADMIN] COPY errors when trying to convert from 7.4.19 to 8.3.1

2008-05-01 Thread Geoffrey
Tom Lane wrote: Geoffrey <[EMAIL PROTECTED]> writes: We are trying to test our process for upgrading our database from 7.4.19 to 8.3.1. We are following the instructions for dumping the 7.4.19 database from: http://www.postgresql.org/docs/8.3/static/install-upgrading.html ie: /usr/local/pg83/

Re: [ADMIN] COPY errors when trying to convert from 7.4.19 to 8.3.1

2008-05-01 Thread Shane Ambler
Geoffrey wrote: We are trying to test our process for upgrading our database from 7.4.19 to 8.3.1. We are following the instructions for dumping the 7.4.19 database from: http://www.postgresql.org/docs/8.3/static/install-upgrading.html ie: /usr/local/pg83/bin/pg_dumpall -h master -p 5434 |g

Re: [ADMIN] COPY errors when trying to convert from 7.4.19 to 8.3.1

2008-05-01 Thread Tom Lane
Geoffrey <[EMAIL PROTECTED]> writes: > We are trying to test our process for upgrading our database from 7.4.19 > to 8.3.1. We are following the instructions for dumping the 7.4.19 > database from: > http://www.postgresql.org/docs/8.3/static/install-upgrading.html > ie: > /usr/local/pg83/bin/pg_