SEO

On Wed, 2006-02-15 at 09:36, Fabrice.Sznajderman@devoteam.com wrote:
> I know I know I too behind!
> But for this moment my project manager wants to stay with this
> version...
>
> There is lot specific developpement around this version ... it not
> easy to change the version...
>
> I asked to my project manager : we must upgrade !! he answser me.. not
> for this moment!
>
> so!!.... :-(
>
> thank a lot for your answer!

Just make sure you're running the latest version of 7.3.x. Earlier
versions of 7.3 had some data loss issues if I remember correctly. It's
always a good practice to be running the latest patch level of your
version of PostgreSQL.

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

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 ..

Thanks a lot in advance!






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

A
Fabrice.Sznajderman@devoteam.com
cc

Objet
Re: [JDBC] In or Exists?






On Wed, 2006-02-15 at 09:36, Fabrice.Sznajderman@devoteam.com wrote:
> I know I know I too behind!
> But for this moment my project manager wants to stay with this
> version...
>
> There is lot specific developpement around this version ... it not
> easy to change the version...
>
> I asked to my project manager : we must upgrade !! he answser me.. not
> for this moment!
>
> so!!.... :-(
>
> thank a lot for your answer!

Just make sure you're running the latest version of 7.3.x. Earlier
versions of 7.3 had some data loss issues if I remember correctly. It's
always a good practice to be running the latest patch level of your
version of PostgreSQL.

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


+---------------------------------------------------------------------+
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
+---------------------------------------------------------------------+

Hi, Fabrice,

Fabrice.Sznajderman@devoteam.com wrote:

> 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 ..

use psql or another command line tool, and send the query
SELECT VERSION();

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 5: don't forget to increase your free space map settings

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 --version
psql (PostgreSQL) 8.1.2
....



or...

$ psql --version
psql (PostgreSQL) 7.4.5

(two different machines here)


this just shows the version of psql itself, which SHOULD be the same as
your server version. if you want to confirm this,

$ psql -c "show server_version;"
server_version
----------------
7.4.5
(1 row)


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

http://www.postgresql.org/docs/faq

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