| From: | "Net Tree Inc(dot)" <nettreeinc(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how do I do dump and restore without bugging with constraint? |
| Date: | 2010-02-23 09:17:30 |
| Message-ID: | bd9689741002230117k7dd7250r31dcfc6a556db44d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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(at)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(dot)Grittner(at)wicourts(dot)gov
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Lea | 2010-02-23 09:35:51 | Re: how do I do dump and restore without bugging with constraint? |
| Previous Message | Scott Marlowe | 2010-02-23 07:31:29 | Re: how do I do dump and restore without bugging with constraint? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gage | 2010-02-23 09:22:21 | Re: Sorting performance vs. MySQL |
| Previous Message | adam_pgsql | 2010-02-23 09:16:28 | "make check" failed on 8.4.2 install |