From: "Anibal David Acosta" <aa@devshock.com>
To: =?utf-8?Q?'Rados=C5=82aw_Smogura'?= <rsmogura@softperience.eu>,
	"'Craig Ringer'" <craig@postnewspapers.com.au>
Cc: <pgsql-admin@postgresql.org>,
	<pgsql-general@postgresql.org>
References: <007101cb917a$cadbc830$60935890$@devshock.com>
	<4CF7520A.3030808@postnewspapers.com.au>
	<a7a7be1ba29ce1e46816538cd87daa70@smogura-softworks.eu>
In-Reply-To: <a7a7be1ba29ce1e46816538cd87daa70@smogura-softworks.eu>
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>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQFee/gcoLz11AIYIfoZzOAYFzTkggISEKf1AXIV1N6USxgg8A==
Content-Language: es-py

Thanks!!!

I'll download right now :)


-----Mensaje original-----
De: Rados=C5=82aw Smogura [mailto:rsmogura@softperience.eu]=20
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.z=
ip
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=C5=82aw 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:
>=20
>> 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.
>>=20
>> So, I don't know how to recover the database from the data directory =
of
a
>> windows postgres 8.1 installation.
>=20
> First and most important: only work on a COPY of the recovered files.
> Keep an original, untouched copy somewhere read-only and safe.
>=20
> 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.
>=20
>=20
> BTW, 8.1 was EOL'd in 2007:
>=20
>     http://www.postgresql.org/about/news.865
>=20
> 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.
>=20
>=20
> Not that I can throw stones - I have:
>=20
>   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)
>=20
> here among other scary dinosaurs I can't yet get rid of for one reason
> or another.
>=20
> * 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.
>=20
> ** 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...
>=20
> --=20
> System & Network Administrator
> POST Newspapers