From: Craig Ringer <craig@postnewspapers.com.au>
To: Anibal David Acosta <aa@devshock.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Cc: magnus@hagander.net
Subject: Re: [GENERAL] How to recover a postgres installation from files
Date: Thu, 02 Dec 2010 15:44:26 +0800
Message-ID: <4CF74E5A.8060802@postnewspapers.com.au> (raw)
In-Reply-To: <007101cb917a$cadbc830$60935890$@devshock.com>
References: <007101cb917a$cadbc830$60935890$@devshock.com>
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
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: craig@postnewspapers.com.au, aa@devshock.com, pgsql-general@postgresql.org, magnus@hagander.net
Subject: Re: [GENERAL] How to recover a postgres installation from files
In-Reply-To: <4CF74E5A.8060802@postnewspapers.com.au>
* 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