Thread: restoring ver 7.2 database
I've really done it this time. I upgraded to Linux Mandrake 9.1. Now my pgsql version is 7.3. My database was version 7.2, and postmaster won't start. I have a copy of the old data (v7.2). Just a `mv /varr/lib/pgsql backuppoint`. pg_dumpall (from v7.3.2) didn't work, because postmaster wasn't running (refused to start) . How can I restore my old data? install a local version 7.2 somewhere and tell it that the data lie on backuppoint? In order to do that I need the source files for v7.2, are they available somwhere? TIA andrass -- Andrass Ziska Davidsen c960334@student.dtu.dk DTU-stud.no.: c9603343
On Tuesday 06 May 2003 11:04 am, Andrass Ziska Davidsen wrote: > I've really done it this time. I upgraded to Linux Mandrake 9.1. Now my > pgsql version is 7.3. My database was version 7.2, and postmaster won't > start. Sorry, but ALWAYS dump/backup any databases before upgrading. And remember that a simple file backup is useless unless you stop PG first and even then won't transfer between versions (as you've found out). > How can I restore my old data? > > install a local version 7.2 somewhere and tell it that the data lie on > backuppoint? Yep > In order to do that I need the source files for v7.2, are they > available somwhere? Go to http://www.postgresql.org/ and click the download link near the top of the page. Select a suitable mirror and look in pub/source/... Installing from source isn't difficult, but make sure you read the instructions before you do so. -- Richard Huxton
On Tuesday 06 May 2003 13:06, Richard Huxton wrote: > Go to http://www.postgresql.org/ and click the download link near the top > of the page. Select a suitable mirror and look in pub/source/... > Installing from source isn't difficult, but make sure you read the > instructions before you do so. Thank you for your quick reply. I have found the sources. And have gone for 7.2.4 (I can't remember the old subversion number, but it shouldn't make any difference with respect to data-format, right?) Originally I got an error when compiling: An undefined reference to `errno' in `DoCopy'. A search on Google gave me the solution. I included `#include <errno.h>' in src/backend/commands/copy.c. And it worked. Thank you for your help. Now I will try to restore my data. Andrass -- Andrass Ziska Davidsen c960334@student.dtu.dk DTU-stud.no.: c9603343