Обсуждение: How to recover a postgres installation from files
Hello. I have a not bootable Windows Server with Postgres 8.1, now I am trying to recover it but as I can't boot the windows, I can't start the postgres service and I can't do a "Backup" 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. Can you help me?
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
On Thu, Dec 2, 2010 at 08:44, Craig Ringer <craig@postnewspapers.com.au> wrote: > 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. Not only is it unwise, but it's fully unsupported... > 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: Yeah, that's a good point. They should probably have been moved to ftp-archives, but I can't find anything there either. (The versions that are there appear to basically completely random at least for binary distributions, but there is nothing for win32 in the 8.1 series) > 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 . Yeah, i don't have one of those around. And I don't see any active buildfarm member building 8.1 on Win32 either (given that it's been desupported for years, I'm sure), so it's not easy to lift from there. Nor do I have a build environment around that could build one anymore - perhaps Dave as something sitting around that could be revived to do a single build? Failing that, the OP will just have to build from source himself. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
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
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
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