From: Anibal David Acosta <aa@devshock.com>
To: 'Radosław Smogura' <rsmogura@softperience.eu>
To: 'Craig Ringer' <craig@postnewspapers.com.au>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to recover a postgres installation from files
Date: Thu, 2 Dec 2010 09:02:40 -0300
Message-ID: <000a01cb9218$d3d01150$7b7033f0$@devshock.com> (raw)
In-Reply-To: <a7a7be1ba29ce1e46816538cd87daa70@smogura-softworks.eu>
References: <007101cb917a$cadbc830$60935890$@devshock.com>
<4CF7520A.3030808@postnewspapers.com.au>
<a7a7be1ba29ce1e46816538cd87daa70@smogura-softworks.eu>
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.zipftp://po.istu.ru/public/distrib/Windows/Devel/db/postgresql/postgresql-8.1.5-1.zipftp://ftp.lviv.farlep.net/opensource/DataBases/postgresql-8.1.2-1.zipftp://svimik.servehttp.com/soft/postgresql-8.1.4-1.zipftp://isyrkov.dialup.corbina.ru/Soft/SQL/PostgreSQL-8.1.3-1.zipftp://ftp.uni-duisburg.de/Databases/PostgreSQL/Win32/postgresql-8.1.1-1.zipftp://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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aa@devshock.com, rsmogura@softperience.eu, craig@postnewspapers.com.au, pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to recover a postgres installation from files
In-Reply-To: <000a01cb9218$d3d01150$7b7033f0$@devshock.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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