Re: [GENERAL] How to recover a postgres installation from files - Mailing list pgsql-admin

Thanks!!!

I'll download right now :)



-----Mensaje original-----
De: Radosław Smogura [mailto:rsmogura@softperience.eu]
Enviado el: jueves, 02 de diciembre de 2010 08:22 a.m.
Para: Craig Ringer
CC: Anibal David Acosta; pgsql-admin@postgresql.org; pgsql-general@postgresql.org
Asunto: Re: [GENERAL] How to recover a postgres installation from files

ftp://svimik.servehttp.com/soft/postgresql-8.1.4-1-binaries-no-installer.zip
ftp://po.istu.ru/public/distrib/Windows/Devel/db/postgresql/postgresql-8.1.5-1.zip
ftp://ftp.lviv.farlep.net/opensource/DataBases/postgresql-8.1.2-1.zip
ftp://svimik.servehttp.com/soft/postgresql-8.1.4-1.zip
ftp://isyrkov.dialup.corbina.ru/Soft/SQL/PostgreSQL-8.1.3-1.zip
ftp://ftp.uni-duisburg.de/Databases/PostgreSQL/Win32/postgresql-8.1.1-1.zip
ftp://ftp.lviv.farlep.net/opensource/DataBases/postgresql-8.1.2-1.zip

I found this on 8 server over world, even archie didn't helped. I'm really
(negatively) suppressed how simple is to delete something from Internet. I
thought it will be simpler to find in internet any old soft. If something
like this will happen with GCC?


Remember to keep copy original DB files, to don't destroy it.
--
----------
Radosław Smogura
http://www.softperience.eu

On Thu, 02 Dec 2010 16:00:10 +0800, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> On 02/12/10 01:11, Anibal David Acosta wrote:
>
>> So, I only have the postgres directory on my hands. I decide to install
>> the
>> same database version in another computer and replace DATA directory,
>> but I
>> notice that 8.1 (windows binary) is not available for download.
>>
>> So, I don't know how to recover the database from the data directory of
a
>> windows postgres 8.1 installation.
>
> First and most important: only work on a COPY of the recovered files.
> Keep an original, untouched copy somewhere read-only and safe.
>
> My other mail should provide you with some info on how to get 8.1 .
> Hopefully Magnus or someone else will provide a better source of 8.1
> installer binaries, but if not then the ones I linked to may be a viable
> option.
>
>
> BTW, 8.1 was EOL'd in 2007:
>
>     http://www.postgresql.org/about/news.865
>
> Once you get your data accessible, do a full dump IMMEDIATELY; you need
> to upgrade to a supported version of PostgreSQL before resuming using
> the database. 8.1 is not only old, but pretty unsafe on Windows. If your
> organization has had it around this long after EOL, you need to look at
> your software management policies.
>
>
> Not that I can throw stones - I have:
>
>   Windows NT 4 [1996, final eol in 2004]
>   Sybase SQL Anywhere 5.5 [1995, eol 2002]
>   SCO OpenServer 5.0.5 [1995, eol 2004, company no longer exists*]
>   Plain English 4GL [?, eol 1983, company gone by 1985**]
>   Microsoft Office Word 2000
>   Mac OS 9.2.2 (PowerPC G4) with an Apple Desktop Bus hardware dongle
>   Windows 98 (running in a VM; runs a win16 app with 16-bit ODBC)
>
> here among other scary dinosaurs I can't yet get rid of for one reason
> or another.
>
> * There's someone wearing their name and their skin, but it's not really
> SCO (the Santa Cruz Operation). The SCO Group are peddling the old
> versions of the OS with minimal engineering support and knowledge. About
> the only interesting thing they've done is repacked OpenServer 6 into a
> canned VM image with a couple of drivers, because it was a bit
> tempramental to install on many VM systems.
>
> ** This runs in the Microsoft Xenix kernel personality on the SCO
> OpenServer box. SCO 5.0.5 is the *newest* OS it'll run on. And no, I
> don't have source code or I would've ported it to something civilized
> long ago. The app it runs relies too much on freaky bugs and quirks in
> the interpreter for a reimplementation to be viable; I know, I tried. A
> rewrite of the app Plain English runs is in progress...
>
> --
> System & Network Administrator
> POST Newspapers