| From: | Gustavo Franklin Nóbrega - Planae <gfnobrega(at)planae(dot)com(dot)br> | 
|---|---|
| To: | "denis moeller" <nimbus(at)latrina(dot)de>, <pgsql-admin(at)postgresql(dot)org> | 
| Subject: | Re: Upgrading 7.3 -> 7.4.5 | 
| Date: | 2005-02-22 17:33:02 | 
| Message-ID: | 054601c51904$906ddd90$d700a8c0@gfnobrega | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
Hi,
    You try to dump with -d (dump data as INSERT, rather than COPY, 
commands) option of pg_dump and import this in 7.4?
Atenciosamente,
Gustavo Franklin Nóbrega
Infraestrutura e Banco de Dados
Planae Tecnologia da Informação
(+55) 14 2106-3514
http://www.planae.com.br
----- Original Message ----- 
From: "denis moeller" <nimbus(at)latrina(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, February 22, 2005 2:36 PM
Subject: [ADMIN] Upgrading 7.3 -> 7.4.5
> Hi,
>
>
> situation: old server backup. Backup of Postgresql data files. Postgres 
> 7.3.x was running.
> New server has version 7.4.5 - how do I get the old data in my new 
> database?
> Copying didn't work - complains about different versions.
>
> TIA!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
> 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | denis moeller | 2005-02-22 17:36:22 | Upgrading 7.3 -> 7.4.5 | 
| Previous Message | Dick Davies | 2005-02-22 16:14:23 | Re: pg_hba.conf |