Re: [GENERAL] How to recover a postgres installation from files

On 02/12/10 01:11, Anibal David Acosta wrote:

> So, I don't know how to recover the database from the data directory of a
> windows postgres 8.1 installation.

You'll need PostgreSQL 8.1 for Windows. This appears to have been
removed from the FTP site for the well-intentioned reason that, on
Windows, it's pretty scarily buggy and it's unwise to use anything prior
to 8.2 on Windows, but people keep on trying to install ancient versions
for new deployments for some bizarre reason.

Unfortunately, this doesn't consider the needs of anybody who has an
existing 8.1 database. The 8.1 win32 installers clearly used to be
hosted by the project, as:

http://www.postgresql.org/about/news.422

links to:

http://www.postgresql.org/ftp/binary/v8.1.0/win32

which no longer exists.

Does anyone have a copy of the win32 installer for such an ancient
version kicking around? If so, IMO the most recent 8.1 really needs to
be on postgresql.org, even if it's within a password-protected folder
that forces you to type "I don't care if this eats all my data" as the
password before downloading...

I've CC'd Magnus Hagander as he's listed as the installer maintainer for
the old msi installers on http://pgfoundry.org/projects/pginstaller .

I've found a copy of some version of the installer here:

http://www.postgresql.at/download/

... but who knows which version it is, if it's configured the same, and
whether or not it's safe. If you want to give it a go you'll need to
download both postgresql-8.1-int.msi and postgresql-8.1.msi and put them
in the same directory before running postgresql-8.1.msi.

--
System & Network Administrator
POST Newspapers