On 2011-01-27, Girts Laudaks <laudaksg@xxxxxxxxx> wrote: > Hi, > > What could be the possible damage if a database is migraged without the > -o (OID) option? Integrity of data? some things that used OID might fail to work. Postgres doesn't need them, does your application? > 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? It does if you use the correct version. > 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 that should work if you use the version 9 pg_dumpall -- ââ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
