From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dumpall without OID |
Date: | 2011-01-28 20:51:38 |
Message-ID: | ihva8q$7t3$1@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2011-01-27, Girts Laudaks <laudaksg(at)gmail(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2011-01-28 21:00:21 | Re: error while trying to change the database encoding on a database |
Previous Message | dennis jenkins | 2011-01-28 19:19:10 | Postgresql-8.4.6, 64bit, Solaris 10u9, dtrace |