Problem while OS-Update

[Heiko Pohl]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Tom Lane]

Heiko Pohl <He********@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:

http://developer.postgresql.org/cvsw...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

[Tom Lane]

Heiko Pohl <He********@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:

http://developer.postgresql.org/cvsw...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

[Heiko Pohl]

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 <He********@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:

http://developer.postgresql.org/cvsw...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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

Heiko Pohl <He********@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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Heiko Pohl]

Tom Lane wrote:

Heiko Pohl <He********@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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

Heiko Pohl <He********@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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Heiko Pohl]

Tom Lane wrote:

Heiko Pohl <He********@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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html