Обсуждение: pgsql 7.0 recovery to 7.4

Hi!
I've just suffered a serious disk meltdown. Successfully I've got
all the files from pgsql 7.0 backed up.
Now I have problem because 7.4 won't read them (obviuos).
Is there a way to upgrade those files to v7.4?
I've tried to compile v7.0 on my slack 9.1 but it won't.

I will not insinst nor be insolent but need help fast.
Thanks!
--
   Marcin Gil :: marcin.gil@audax.com.pl
   OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
   tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25

Marcin Gil <marcin.gil@audax.com.pl> writes:
> I've just suffered a serious disk meltdown. Successfully I've got
> all the files from pgsql 7.0 backed up.
> Now I have problem because 7.4 won't read them (obviuos).
> Is there a way to upgrade those files to v7.4?

You mean a filesystem-level dump of the data directory?  Sorry, the
only way to deal with that is to install 7.0.something and then make
a pg_dump or pg_dumpall dump.

> I've tried to compile v7.0 on my slack 9.1 but it won't.

I wouldn't be too surprised if it needs some minor tweaking for newer
Linuxen.

            regards, tom lane

Tom Lane wrote:

> You mean a filesystem-level dump of the data directory?  Sorry, the
> only way to deal with that is to install 7.0.something and then make
> a pg_dump or pg_dumpall dump.
>
That's what I'm doing right now :( Getting RedHat 6.2 was quite
a challenge :)

 > I wouldn't be too surprised if it needs some minor tweaking for newer
 > Linuxen.

I'd rather install an old one - it's faster.

For the future:
- how should I dump my databases to omit such problems?
- is pg_dump format compatible, ie will loading 7.0 version into 7.4 go
   without a glitch?

--
   Marcin Gil :: marcin.gil@audax.com.pl
   OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
   tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25

Marcin Gil <marcin.gil@audax.com.pl> writes:
> For the future:
> - how should I dump my databases to omit such problems?

pg_dump or pg_dumpall

> - is pg_dump format compatible, ie will loading 7.0 version into 7.4 go
>    without a glitch?

Yes, it should.  Actually the best practice for an upgrade is to run the
newer version's pg_dump against the older server, if you can.  That way
you get the benefit of any pg_dump bug fixes in the newer version.

            regards, tom lane

Tom Lane wrote:

> pg_dump or pg_dumpall

I have installed 7.0.3 and run it with these binary files I've got.
There was a second install of v7.2 - and I did pg_dump with this.
I landed with pack of .tar files (-F t -c -C -b).
Now, when I try to do pg_restore of these files (with -C option)
none of these databases shows up in 7.4..
What can I do or what I am doing wrong.

One ot these files as attachment.
Thanks!
--
   Marcin Gil :: marcin.gil@audax.com.pl
   OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
   tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25