Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: denis moellerDate: 2005-02-22 17:36:22
Subject: Upgrading 7.3 -> 7.4.5
Previous:From: Dick DaviesDate: 2005-02-22 16:14:23
Subject: Re: pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group