Hi,
What could be the possible damage if a database is migraged without the
-o (OID) option? Integrity of data?
What are the options to solve this problem if it is migrated this way?
Shouldn't pg_dumpall work like an exact copy of db?
What could have gone wrong if only these commands were used?
pg_dumpall -v -U postgres | gzip > /var/lib/pgsql/dump.data.gz
gunzip -c /var/lib/pgsql/dump.data.gz | psql -U postgres >> /tmp/import.log
They were used to migrate from PG8.4 to PG9
Regards,
Girts