pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Postgres Date pg_dump/Import:
3+ messages / 2 participants
[nested] [flat]
* Re: Postgres Date pg_dump/Import:
@ 2002-11-12 20:12 Martin Crundall <pgsql@ac6rm.net>
2002-11-12 20:41 ` Re: Postgres Date pg_dump/Import: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Martin Crundall @ 2002-11-12 20:12 UTC (permalink / raw)
To: pgsql-sql
Tom;
Not sure how to tell. I didn't explicitly specify anything like this
during the ./configure step of install. Poking around in the souce
directory, I pulled this out of config.cache ...
configure:1243: checking whether the C compiler (gcc -O9 -funroll-loops
-ffast-math -malign-double -mcpu=pentiumpro -march=pentiumpro
-fomit-frame-pointer -fno-exceptions ) works
Note, I didn't use the postgresql that came with Slackware; I downloaded
it from the postgres web site.
Martin
>> i am currently running 7.2.2 on slackware 8.1 (kernel 2.4.18)
>
> BTW, is it possible that your postgres was built with -ffast-math
> in CFLAGS? That is known to cause symptoms like this. Unfortunately
> -ffast-math is in the default CFLAGS on some Linux distros.
>
> regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres Date pg_dump/Import:
2002-11-12 20:12 Re: Postgres Date pg_dump/Import: Martin Crundall <pgsql@ac6rm.net>
@ 2002-11-12 20:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-11-12 21:19 ` Re: Postgres Date pg_dump/Import: Martin Crundall <pgsql@ac6rm.net>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2002-11-12 20:41 UTC (permalink / raw)
To: pgsql@ac6rm.net; +Cc: pgsql-sql
"Martin Crundall" <pgsql@ac6rm.net> writes:
> Not sure how to tell. I didn't explicitly specify anything like this
> during the ./configure step of install. Poking around in the souce
> directory, I pulled this out of config.cache ...
> configure:1243: checking whether the C compiler (gcc -O9 -funroll-loops
> -ffast-math -malign-double -mcpu=pentiumpro -march=pentiumpro
^^^^^^^^^^^
> -fomit-frame-pointer -fno-exceptions ) works
Bingo: something is supplying a whole bunch of "helpful" optimization
options, including -ffast-math which is what's causing your problem.
Left to its own devices, configure would have only selected "-O2" as
the default flags for gcc.
I suspect if you try "env | grep CFLAGS" you will find that the problem
is a CFLAGS environment variable that you're inheriting from somewhere.
If so, you could "unset CFLAGS" and then re-run configure, rebuild,
reinstall (you won't need to initdb fortunately, just reinstall the
executables).
If it's not coming from a CFLAGS environment variable setting then
you'll need to look harder.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres Date pg_dump/Import:
2002-11-12 20:12 Re: Postgres Date pg_dump/Import: Martin Crundall <pgsql@ac6rm.net>
2002-11-12 20:41 ` Re: Postgres Date pg_dump/Import: Tom Lane <tgl@sss.pgh.pa.us>
@ 2002-11-12 21:19 ` Martin Crundall <pgsql@ac6rm.net>
0 siblings, 0 replies; 3+ messages in thread
From: Martin Crundall @ 2002-11-12 21:19 UTC (permalink / raw)
To: tgl@sss.pgh.pa.us; +Cc: pgsql-sql
Tom;
IT WORKED! This is what I did:
env | grep CFLAGS
and that produced all those flags as you predicted (-O9 -funroll-loops
-ffast-math -malign-double -mcpu=pentiumpro -march=pentiumpro)
unset CFLAGS
make clean
./configure --enable-odbc
make
make install
a subsequent pg_dump of the staging system's database produced NO ":60"
substrings in any time stamps!
Thanks much for your help!
Martin
p.s. interesting to note -- my dev box is actually the same distro
(slackware 8.1) but running in a vmware window. there was no such CFLAGS
env variable set and pg_dumps on the dev box are ok. the distro install
must set the CFLAGS based on hardware (the laptop is a Compaq PIII/700,
and the staging box is a P4/1.7G on an intel chipset board). Anyway,
really happy this worked -- thanks again. Let me know if there's anything
I can do.
> "Martin Crundall" <pgsql@ac6rm.net> writes:
>> Not sure how to tell. I didn't explicitly specify anything like this
>> during the ./configure step of install. Poking around in the souce
>> directory, I pulled this out of config.cache ...
>
>> configure:1243: checking whether the C compiler (gcc -O9
>> -funroll-loops -ffast-math -malign-double -mcpu=pentiumpro
>> -march=pentiumpro
> ^^^^^^^^^^^
>> -fomit-frame-pointer -fno-exceptions ) works
>
> Bingo: something is supplying a whole bunch of "helpful" optimization
> options, including -ffast-math which is what's causing your problem.
> Left to its own devices, configure would have only selected "-O2" as the
> default flags for gcc.
>
> I suspect if you try "env | grep CFLAGS" you will find that the problem
> is a CFLAGS environment variable that you're inheriting from somewhere.
> If so, you could "unset CFLAGS" and then re-run configure, rebuild,
> reinstall (you won't need to initdb fortunately, just reinstall the
> executables).
>
> If it's not coming from a CFLAGS environment variable setting then
> you'll need to look harder.
>
> regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-11-12 21:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-12 20:12 Re: Postgres Date pg_dump/Import: Martin Crundall <pgsql@ac6rm.net>
2002-11-12 20:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-11-12 21:19 ` Martin Crundall <pgsql@ac6rm.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox