Dumpall without OID

From: Girts Laudaks <laudaksg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dumpall without OID
Date: 2011-01-27 12:52:58
Message-ID: 4D416AAA.2000308@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Kemanetzis 2011-01-27 14:04:02 Select query ignores index on large table
Previous Message Arturo Perez 2011-01-27 12:32:15 Re: temporal period type and select distinct gives equality error