pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres help
3+ messages / 3 participants
[nested] [flat]

* postgres help
@ 2005-04-09 09:46 goa <goalinux@yahoo.com>
  2005-04-11 01:45 ` Re: postgres help Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 3+ messages in thread

From: goa @ 2005-04-09 09:46 UTC (permalink / raw)
  To: pgsql-admin

We had developed some apllication with postgres-7.0.3-8 as back end
now that we have upgraded all our servers to redhat9.0,also we cannot use new version of postgres since there is some issues with date fields which we use of postgres-7.0
 
I am not able to compile postgresql-7.0.3-8 on redhat
9.0
i am getting following error
checking for POSIX signal interface... yes
checking for tclsh... (cached) /usr/bin/tclsh
creating ./config.status
creating GNUmakefile
sed: file conftest.s1 line 35: Unterminated `s'
command
creating Makefile.global
sed: file conftest.s1 line 35: Unterminated `s'
command
creating backend/port/Makefile
sed: file conftest.s1 line 35: Unterminated `s'
command
creating backend/catalog/genbki.sh
sed: file conftest.s1 line 35: Unterminated `s'
command
creating backend/utils/Gen_fmgrtab.sh
sed: file conftest.s1 line 35: Unterminated `s'
command
creating bin/pg_dump/Makefile
sed: file conftest.s1 line 35: Unterminated `s'
command
creating bin/pg_version/Makefile
sed: file conftest.s1 line 35: Unterminated `s'
command
creating bin/pgtclsh/mkMakefile.tcldefs.sh
...........

help 




		
---------------------------------
Do you Yahoo!?
 Make Yahoo! your home page   

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgres help
  2005-04-09 09:46 postgres help goa <goalinux@yahoo.com>
@ 2005-04-11 01:45 ` Michael Fuhr <mike@fuhr.org>
  2005-04-11 06:25   ` Re: postgres help Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Michael Fuhr @ 2005-04-11 01:45 UTC (permalink / raw)
  To: goa <goalinux@yahoo.com>; +Cc: pgsql-admin

On Sat, Apr 09, 2005 at 02:46:01AM -0700, goa wrote:
>
> We had developed some apllication with postgres-7.0.3-8 as back end
> now that we have upgraded all our servers to redhat9.0,also we cannot
> use new version of postgres since there is some issues with date fields
> which we use of postgres-7.0

Could you elaborate on those issues?  7.0.3 is over four years
old -- aside from new functionality in later releases, there have
been numerous bug fixes since then.  You really should consider
using a newer version; I'm sure the people on these lists would be
willing to help solve whatever problems that might cause.

> I am not able to compile postgresql-7.0.3-8 on redhat 9.0
> i am getting following error
> checking for POSIX signal interface... yes
> checking for tclsh... (cached) /usr/bin/tclsh
> creating ./config.status
> creating GNUmakefile
> sed: file conftest.s1 line 35: Unterminated `s' command

Does "gcc --version" return more than one line?  According to the
following message, that was a problem that got fixed in 7.2.

http://archives.postgresql.org/pgsql-ports/2003-04/msg00015.php

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: postgres help
  2005-04-09 09:46 postgres help goa <goalinux@yahoo.com>
  2005-04-11 01:45 ` Re: postgres help Michael Fuhr <mike@fuhr.org>
@ 2005-04-11 06:25   ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2005-04-11 06:25 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: goa <goalinux@yahoo.com>; pgsql-admin

Michael Fuhr <mike@fuhr.org> writes:
> On Sat, Apr 09, 2005 at 02:46:01AM -0700, goa wrote:
>> We had developed some apllication with postgres-7.0.3-8 as back end
>> now that we have upgraded all our servers to redhat9.0,also we cannot
>> use new version of postgres since there is some issues with date fields
>> which we use of postgres-7.0

> Could you elaborate on those issues?  7.0.3 is over four years
> old -- aside from new functionality in later releases, there have
> been numerous bug fixes since then.  You really should consider
> using a newer version; I'm sure the people on these lists would be
> willing to help solve whatever problems that might cause.

The oldest version that the community considers even slightly supported
is 7.2.*.  7.1.* and before have fundamental, unfixable data-loss risks
(for instance, after 4 billion transactions you WILL lose all your data
in 7.0.*).  So you would be far better advised to spend your effort on
fixing your application to make it play with a current PG release than
on trying to recompile such an ancient release.

BTW, with my Red Hat hat on, I would say that RHL9 is about equally
obsolete.  Why aren't you updating to a more modern platform, if you're
troubling to update at all?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-04-11 06:25 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-09 09:46 postgres help goa <goalinux@yahoo.com>
2005-04-11 01:45 ` Michael Fuhr <mike@fuhr.org>
2005-04-11 06:25   ` Tom Lane <tgl@sss.pgh.pa.us>

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