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
>
>
>
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? |