pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Upgrading 7.3 -> 7.4.5
7+ messages / 5 participants
[nested] [flat]

* Upgrading 7.3 -> 7.4.5
@ 2005-02-22 17:36 denis moeller <nimbus@latrina.de>
  2005-02-22 17:33 ` Re: Upgrading 7.3 -> 7.4.5 Gustavo Franklin Nóbrega - Planae <gfnobrega@planae.com.br>
  2005-02-22 17:38 ` Re: Upgrading 7.3 -> 7.4.5 Scott Marlowe <smarlowe@g2switchworks.com>
  2005-02-22 17:55 ` Re: Upgrading 7.3 -> 7.4.5 Bruno Wolff III <bruno@wolff.to>
  2005-02-22 18:50 ` Re: Upgrading 7.3 -> 7.4.5 Aufkleber24.de <info@aufkleber24.de>
  2005-02-22 19:15 ` Re: Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
  0 siblings, 5 replies; 7+ messages in thread

From: denis moeller @ 2005-02-22 17:36 UTC (permalink / raw)
  To: pgsql-admin

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!




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrading 7.3 -> 7.4.5
  2005-02-22 17:36 Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
@ 2005-02-22 17:33 ` Gustavo Franklin Nóbrega - Planae <gfnobrega@planae.com.br>
  4 siblings, 0 replies; 7+ messages in thread

From: Gustavo Franklin Nóbrega - Planae @ 2005-02-22 17:33 UTC (permalink / raw)
  To: denis moeller <nimbus@latrina.de>; 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@latrina.de>
To: <pgsql-admin@postgresql.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
> 




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrading 7.3 -> 7.4.5
  2005-02-22 17:36 Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
@ 2005-02-22 17:38 ` Scott Marlowe <smarlowe@g2switchworks.com>
  4 siblings, 0 replies; 7+ messages in thread

From: Scott Marlowe @ 2005-02-22 17:38 UTC (permalink / raw)
  To: denis moeller <nimbus@latrina.de>; +Cc: pgsql-admin

On Tue, 2005-02-22 at 11:36, denis moeller wrote:
> 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.

Read this part of the manual?

http://www.postgresql.org/docs/8.0/static/install-upgrading.html



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrading 7.3 -> 7.4.5
  2005-02-22 17:36 Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
@ 2005-02-22 17:55 ` Bruno Wolff III <bruno@wolff.to>
  4 siblings, 0 replies; 7+ messages in thread

From: Bruno Wolff III @ 2005-02-22 17:55 UTC (permalink / raw)
  To: denis moeller <nimbus@latrina.de>; +Cc: pgsql-admin

On Tue, Feb 22, 2005 at 18:36:22 +0100,
  denis moeller <nimbus@latrina.de> wrote:
> 
> situation: old server backup. Backup of Postgresql data files. Postgres 
> 7.3.x was running.

You can't take file system level backups under a running postmaster and expect
to use those to recover a database. You either need to shut the postmaster
down or use pg_dump(all) to make a live dump.

> 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.

When switching between major versions (such as 7.3.x to 7.4.x) you need to
do a dump and restore. If possible you should use the pg_dump client of
the newer version to do the dump, as newer versions do a better job of
handling dependencies in dumps.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrading 7.3 -> 7.4.5
  2005-02-22 17:36 Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
@ 2005-02-22 18:50 ` Aufkleber24.de <info@aufkleber24.de>
  4 siblings, 0 replies; 7+ messages in thread

From: Aufkleber24.de @ 2005-02-22 18:50 UTC (permalink / raw)
  To: pgsql-admin

Well ... I don't have an old version running to make a dump - that would 
be easy.
I just got the files in a backup-directory ...
Any ideas?
Thanks!





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrading 7.3 -> 7.4.5
  2005-02-22 17:36 Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
@ 2005-02-22 19:15 ` denis moeller <nimbus@latrina.de>
  2005-02-22 21:15   ` Re: Upgrading 7.3 -> 7.4.5 Bruno Wolff III <bruno@wolff.to>
  4 siblings, 1 reply; 7+ messages in thread

From: denis moeller @ 2005-02-22 19:15 UTC (permalink / raw)
  To: pgsql-admin

Well ... I don't have an old version running to make a dump - that would 
be easy.
I just got the files in a backup-directory ...
Any ideas?
Thanks!




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Upgrading 7.3 -> 7.4.5
  2005-02-22 17:36 Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
  2005-02-22 19:15 ` Re: Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
@ 2005-02-22 21:15   ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 7+ messages in thread

From: Bruno Wolff III @ 2005-02-22 21:15 UTC (permalink / raw)
  To: denis moeller <nimbus@latrina.de>; +Cc: pgsql-admin

On Tue, Feb 22, 2005 at 20:15:26 +0100,
  denis moeller <nimbus@latrina.de> wrote:
> Well ... I don't have an old version running to make a dump - that would 
> be easy.
> I just got the files in a backup-directory ...
> Any ideas?
> Thanks!

You can try reinstalling the old version and doing the dump. However if
the postmaster was running when you made the backups you might be in trouble.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2005-02-22 21:15 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-22 17:36 Upgrading 7.3 -> 7.4.5 denis moeller <nimbus@latrina.de>
2005-02-22 17:33 ` Gustavo Franklin Nóbrega - Planae <gfnobrega@planae.com.br>
2005-02-22 17:38 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-02-22 17:55 ` Bruno Wolff III <bruno@wolff.to>
2005-02-22 18:50 ` Aufkleber24.de <info@aufkleber24.de>
2005-02-22 19:15 ` denis moeller <nimbus@latrina.de>
2005-02-22 21:15   ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox