X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D36418B9EA0 for ; Tue, 22 Feb 2005 17:34:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41426-09 for ; Tue, 22 Feb 2005 17:34:05 +0000 (GMT) Received: from planae.com.br (nat.planae.com.br [200.210.129.190]) by svr1.postgresql.org (Postfix) with SMTP id 9D78C8B9EAD for ; Tue, 22 Feb 2005 17:34:02 +0000 (GMT) Received: (qmail 2253 invoked by uid 1004); 22 Feb 2005 17:37:11 -0000 Received: from 192.168.0.215 by mercurio.planae.com.br (envelope-from , uid 0) with qmail-scanner-1.23 (uvscan: v4.3.20/v4431. Clear:RC:1(192.168.0.215):. Processed in 0.786143 secs); 22 Feb 2005 17:37:11 -0000 Received: from unknown (HELO gfnobrega) (gfnobrega@192.168.0.215) by 192.168.0.3 with SMTP; 22 Feb 2005 17:37:09 -0000 Message-ID: <054601c51904$906ddd90$d700a8c0@gfnobrega> From: =?iso-8859-1?Q?Gustavo_Franklin_N=F3brega_-_Planae?= To: "denis moeller" , References: <421B6D96.80900@latrina.de> Subject: Re: Upgrading 7.3 -> 7.4.5 Date: Tue, 22 Feb 2005 14:33:02 -0300 Organization: =?iso-8859-1?Q?Planae_Tecnologia_da_Informa=E7=E3o?= MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.017 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/225 X-Sequence-Number: 16393 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" To: 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 >