> You can install two different versions of PostgreSQL in different > directories, or you can run pg_dump from the machine which is your > conversion target. We do both. We always build from source, and we > use a --prefix on configure which includes the version. For > example:
I even tried out the recommended upgrade technique also. That is, installed new version (9.0.3 in this case) of PostgreSQL in a different directory in the same machine and used pg_dump of this latest version to access the old database (running 8.2.3 in this case) to take a dump and then imported into 9.0.3. Still I'm facing *exactly* the same set of errors after importing (as I was getting before). ERROR: constraint "xxxx" for relation "xxxx" already exist There are 260 occurrences of this type of error. How do I resolve/fix this problem at this stage? Since this issue we're facing is with our Production database dump, timely suggestions/advice/help to resolve this are highly appreciated. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
