Re: Problem while OS-Update

From: Heiko Pohl <Heiko(dot)Pohl(at)VR-Web(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem while OS-Update
Date: 2004-06-21 20:23:42
Message-ID: 40D743CE.7030104@VR-Web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank You, I installed now the 7.2.4-Version and it works. But how do I
reach my Data? My 7.2.-installation is now in /usr/local/pgsql/ , my
data - also 7.2 - are in /usr/lib/pgsql.old/data/ ...??

Tom Lane wrote:

>Heiko Pohl <Heiko(dot)Pohl(at)VR-Web(dot)de> writes:
>
>
>>upgrading my OS from RedHat 8.0 to FC2, postgresql was also
>>automatically updated from 7.2. to 7.4. Unfortunately, I did not
>>"dumpall"... How can I get my data??? I copied the data-folder to
>>another location and so got running the new postgresql-server. I tried
>>to install the old 7.2.4.tar.gz in a new folder, but it don't go further
>>than ./configure. gmake gives the following lines at the end: (second
>>time tiping gmake)
>>
>>
>
>
>
>>commands/SUBSYS.o(.text+0x420a): In function `DoCopy':
>>: undefined reference to `errno'
>>
>>
>
>You need to add "#include <errno.h>" near the top of
>src/backend/commands/copy.c, as per this patch:
>
>http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/copy.c.diff?r1=1.145.2.1&r2=1.145.2.2
>
>2003-04-11 16:51 tgl
>
> * src/backend/commands/copy.c (REL7_2_STABLE): Add #include
> <errno.h> per recent reports that it's now necessary on RHL 9.
> (Not clear why it didn't break long before, actually...)
>
>We never put out a 7.2.5, so the change didn't see the light of day
>in that branch ...
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-06-21 20:26:33 Re: New to the list; would this be an okay question?
Previous Message Richard Huxton 2004-06-21 19:34:51 Re: virtual fields on VIEW?