I tried select version();

it gave me this:

PostgreSQL 7.2.3-RH on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
20020903 (Red Hat Linux 8.0 3.2-7)

I really newbie with postgres...

Can u help me?
thank in advance!!

Fabrice





Scott Marlowe <smarlowe@g2switchworks.com>
Envoyé par : pgsql-jdbc-owner@postgresql.org
15/02/2006 17:27

A
Fabrice.Sznajderman@devoteam.com
cc

Objet
Re: [JDBC] In or Exists?






On Wed, 2006-02-15 at 09:59, Fabrice.Sznajderman@devoteam.com wrote:
> thank you for your answer!
>
>
> how I can know the version of my postgres DataBase ?
> I know is 7.3.x but I don't know for the 'x' number ..

psql -V will tell you the client version. or psql template1 -c "select
version();" will tell you the version of the backend server.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match


+---------------------------------------------------------------------+
About Devoteam:

Devoteam is an IT consulting group.
Combining consulting and technology solutions offers enables
Devoteam to provide its customers with independent advice and
effective solutions to align their information system's technical
infrastructure with their operational objectives.
The group achieved a turnover of 199 million euros in 2005
an operating margin of 7% and counts 2,100 employees through
12 European countries and the Middle East.
Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy,
IT CAC, IT CAC 50, SBF 250 index of Euronext Paris.
www.devoteam.com
+---------------------------------------------------------------------+

On Wed, 2006-02-15 at 10:27, Fabrice.Sznajderman@devoteam.com wrote:
> I tried select version();
>
> it gave me this:
>
> PostgreSQL 7.2.3-RH on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
> 3.2 20020903 (Red Hat Linux 8.0 3.2-7)

OK... You're running a really really old version of PostgreSQL.

It has known data loss and crash inducing bugs.

Let your boss know that you should upgrade to, at a minimum, the latest
version of 7.2, which is 7.2.8.

7.2 is no longer supported. It's very old. It's creaky in fact. I
would recommend upgrading to the latest 8.0 or 8.1 series, or 7.4 as a
minimum.

Many IT managers prefer to stick with older "known" versions of
software. While I understand this, it's really mostly a comfort issue.

And nothing makes me more uncomfortable than a database error that means
all my data just disappeared.

Oh, and update your OS as well if you can. RH 8.0 is also no longer
supported. It has many unpatched security bugs. You are running an
unreliable, unstable version of postgresql on an unreliable, insecure
platform. Expect no mercy from the gods or the members of this list
when things go wrong. And they will.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Scott Marlowe <smarlowe@g2switchworks.com> writes:
> On Wed, 2006-02-15 at 10:27, Fabrice.Sznajderman@devoteam.com wrote:
>> PostgreSQL 7.2.3-RH on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
>> 3.2 20020903 (Red Hat Linux 8.0 3.2-7)

> OK... You're running a really really old version of PostgreSQL.

In fact, it's so old that I can't even find any trace in Red Hat's
internal CVS of such a version having been released :-(. AFAICT, RHL 8
shipped with Postgres 7.3. I think that this very probably isn't an
official Red Hat RPM at all, but something that was built locally using
already-obsolete Postgres sources.

Upgrade *now*, don't wait to get burnt. And I concur with Scott about
upgrading the whole OS while you're at it.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

> Oh, and update your OS as well if you can. RH 8.0 is also no longer
> supported. It has many unpatched security bugs. You are running an
> unreliable, unstable version of postgresql on an unreliable, insecure
> platform.

indeed. The 'proper' upgrade is a clean install of a up to date
supported distribution, perhaps RHEL4 or CentOS4, or perhaps something
else, however I also know how hard this can be on a production system.

There is an alternative, the Fedora people have a 'fedora legacy'
project which is still supporting RH9 with critical fixes, you can
fairly easily update RH8 to RH9 (they are very similar systems), and
then get the latest updates for this platform.

This will give you some breathing room while you plan the major upgrade
to RHEL4 or something else...

I've done this on some production servers where there was lack of money
or resources to setup a whole new server (these are servers that belong
to 3rd parties for which noone is being paid to run, so there were no
resources available for a proper upgrade).

I would first dump backups of all your postgres databases(!!) Then I'd
make backups of all your core file systems so you can revert if things
backfire on you for unexplained reasons...

then, follow these instructions...
http://www.fedora.us/wiki/LegacyRPMUpgrade

and then these...
http://www.fedoralegacy.org/docs/yum-rh9.php

then remove any and all traces of RH distributions of older postgres
versions (`rpm -qa | grep postgres`, then rpm -e xxxx), install the
latest postgres 8.1 from the RPMs on the postgres download pages, and
recreate your postgres users, and restore your postgres dump, and you
should be good to go.


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

Hi, Fabrice,

Fabrice.Sznajderman@devoteam.com wrote:
>
> I tried select version();
>
> it gave me this:
>
> PostgreSQL 7.2.3-RH [...]

This tells us that you use a Redhat specific PostgreSQL version 7.2, dot
release 7.2.3.

7.2 is pretty old, and not supported by the PostgreSQL team any more
(since the 8.1 release, AFAIR.)

And even for 7.2, 7.2.8 is the newest dot release.

You can fetch it from
ftp://ftp.de.postgresql.org/mirror/p...ql/binary/OLD/
or other postgresql mirrors.



HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Hello,

Thanks a lot for this information! I think I 'll upgrade my environnement
!

Thank for the link to!!!

best regards

Fabrice






Markus Schaber <schabi@logix-tt.com>
Envoyé par : pgsql-jdbc-owner@postgresql.org
15/02/2006 17:41

A
Fabrice.Sznajderman@devoteam.com
cc

Objet
Re: [JDBC] In or Exists?






Hi, Fabrice,

Fabrice.Sznajderman@devoteam.com wrote:
>
> I tried select version();
>
> it gave me this:
>
> PostgreSQL 7.2.3-RH [...]

This tells us that you use a Redhat specific PostgreSQL version 7.2, dot
release 7.2.3.

7.2 is pretty old, and not supported by the PostgreSQL team any more
(since the 8.1 release, AFAIR.)

And even for 7.2, 7.2.8 is the newest dot release.

You can fetch it from
ftp://ftp.de.postgresql.org/mirror/p...ql/binary/OLD/
or other postgresql mirrors.



HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org
www.nosoftwarepatents.org

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


+---------------------------------------------------------------------+
About Devoteam:

Devoteam is an IT consulting group.
Combining consulting and technology solutions offers enables
Devoteam to provide its customers with independent advice and
effective solutions to align their information system's technical
infrastructure with their operational objectives.
The group achieved a turnover of 199 million euros in 2005
an operating margin of 7% and counts 2,100 employees through
12 European countries and the Middle East.
Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy,
IT CAC, IT CAC 50, SBF 250 index of Euronext Paris.
www.devoteam.com
+---------------------------------------------------------------------+