Problem while OS-Update
Hello,
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)
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-Wl,-rpath,/usr/local/pgsql/lib -export-dynamic access/SUBSYS.o
bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o
executor/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o
nodes/SUBSYS.o optimizer/SUBSYS.o port/SUBSYS.o postmaster/SUBSYS.o
regex/SUBSYS.o rewrite/SUBSYS.o storage/SUBSYS.o tcop/SUBSYS.o
utils/SUBSYS.o -lz -lcrypt -lresolv -lnsl -ldl -lm -lbsd -lreadline
-ltermcap -o postgres
commands/SUBSYS.o(.text+0x420a): In function `DoCopy':
: undefined reference to `errno'
commands/SUBSYS.o(.text+0x4210): In function `DoCopy':
: undefined reference to `errno'
commands/SUBSYS.o(.text+0x4317): In function `DoCopy':
: undefined reference to `errno'
commands/SUBSYS.o(.text+0x431d): In function `DoCopy':
: undefined reference to `errno'
collect2: ld returned 1 exit status
gmake[2]: *** [postgres] Fehler 1
gmake[2]: Leaving directory `/usr/local/pgsql/postgresql-7.2.4/src/backend'
gmake[1]: *** [all] Fehler 2
gmake[1]: Leaving directory `/usr/local/pgsql/postgresql-7.2.4/src'
gmake: *** [all] Fehler 2
[root@whisky postgresql-7.2.4]#
There were a lot of lines containing "...Wmissing..."
How can I proceed?
Thanks for help
Heiko
Heiko Pohl <Heiko.Pohl@VR-Web.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:
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
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:
Show quoted text
Heiko Pohl <Heiko.Pohl@VR-Web.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: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?
Heiko Pohl <Heiko.Pohl@VR-Web.de> writes:
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/ ...??
Point the postmaster to that data directory with PGDATA or -D switch.
regards, tom lane
Tom Lane wrote:
Heiko Pohl <Heiko.Pohl@VR-Web.de> writes:
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/ ...??Point the postmaster to that data directory with PGDATA or -D switch.
regards, tom lane
I tried the following:
-bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /var/lib/pgsql.old/data
FATAL 2: The database cluster was initialized with LC_COLLATE
'de_DE.UTF-8' and
LC_CTYPE 'de_DE.UTF-8', but the server was compiled without
locale support.
It looks like you need to initdb or recompile.
-bash-2.05b$
Then:
-bash-2.05b$ /usr/local/pgsql/bin/initdb -D /var/lib/pgsql.old/data/
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
initdb: The directory /var/lib/pgsql.old/data/ exists but is not empty.
If you want to create a new database system, either remove or empty
the directory /var/lib/pgsql.old/data/ or run initdb with
an argument other than /var/lib/pgsql.old/data/.
-bash-2.05b$
How can I recompile? Or is there another possibility?
Heiko
Heiko Pohl <Heiko.Pohl@VR-Web.de> writes:
-bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /var/lib/pgsql.old/data
FATAL 2: The database cluster was initialized with LC_COLLATE
'de_DE.UTF-8' and
LC_CTYPE 'de_DE.UTF-8', but the server was compiled without
locale support.
It looks like you need to initdb or recompile.
You need configure --enable-locale, or some such switch.
-bash-2.05b$ /usr/local/pgsql/bin/initdb -D /var/lib/pgsql.old/data/
Do NOT NOT NOT initdb, or you'll have wasted this whole exercise.
regards, tom lane
Tom Lane wrote:
Heiko Pohl <Heiko.Pohl@VR-Web.de> writes:
-bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /var/lib/pgsql.old/data
FATAL 2: The database cluster was initialized with LC_COLLATE
'de_DE.UTF-8' and
LC_CTYPE 'de_DE.UTF-8', but the server was compiled without
locale support.
It looks like you need to initdb or recompile.You need configure --enable-locale, or some such switch.
Got it!!! :-))))
I have my data now running on the 7.4-server and nothing is lost. Great!
Thank You very much!
Heiko Pohl