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

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
>


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

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/s...upgrading.html

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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!


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

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!



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org