Re: how do I do dump and restore without bugging with constraint?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



It is unreasonable to expect 8.3 programs to be able to understand
everything that 8.4 programs might write.

What format is your dump in?  Plain text (--format=p) might work.  Or
try dumping the 8.4 database with the 8.3 version of pg_dump, or maybe
use the 8.4 pg_restore against the 8.3 database.


--
Ian.


On Tue, Feb 23, 2010 at 9:17 AM, Net Tree Inc. <nettreeinc@xxxxxxxxx> wrote:
> Why am I keep getting error with version issues.... I am trying to restore a
> backup file from a 8.4 postgresql server to a 8.3 postgresql server.
> [postgres@localhost ~]$ pg_restore -C -d postgres -i isamdb.backup
> pg_restore.bin: [archiver] unsupported version (1.11) in file header
>
> On Tue, Feb 23, 2010 at 1:02 PM, Kevin Grittner
> <Kevin.Grittner@xxxxxxxxxxxx> wrote:
>>
>> "Net Tree Inc."  wrote:
>>
>> > When I do restore it shown alot errors related with constraints.
>> > How can I dump and to restore from old to new without dealing with
>> > constraint and just forces data dump to where it suppose to belong?
>>
>> What version are you dumping from and to?  Exactly what errors are
>> you getting?  (Copy and paste samples, please.)
>>
>> You might want to review this page:
>>
>> http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
>>
>> -Kevin
>>
>>
>
>
>
> --
> ---------------------------------------
> Steven Huang
>

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux