Re: Upgrading 7.3 -> 7.4.5

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: Raw Message | Whole Thread | 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
>

In response to

Browse pgsql-admin by date

  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