| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Boris Makovecki" <boris(dot)makovecki(at)abak(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: migration |
| Date: | 2005-02-22 15:23:39 |
| Message-ID: | 9594.1109085819@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Boris Makovecki" <boris(dot)makovecki(at)abak(dot)net> writes:
> I'm having trouble migrating DB from postgreSQL 7.4 to 7.4.7:
> During restore I'm geting all kind of errors like :
> ********************************************************************
> ERROR: column "txt_name" has a type conflict
> DETAIL: character varying versus pg_catalog.varchar
That's pretty bizarre. Can we see the pg_dump output (pg_dump -s
without the data would be plenty)?
BTW, there is no reason to do a dump/restore to migrate to a newer
version in the same release series (7.4.*). Just stop the old
postmaster and start the new one.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-22 15:29:13 | Re: rows and array |
| Previous Message | Stefan.Ardeleanu | 2005-02-22 15:06:27 | FW: execute dynamic strings. need help. |