Re: pgsql error

When I go to "C:\ms4w\apps\pgsql75win\bin" in the command line, and run "postgres --version", I get the following...

"postgres (PostgreSQL) 7.5devel"

John

-----Original Message-----
From: Merlin Moncure [mailto:mmoncure(at)gmail(dot)com]
Sent: Tuesday, July 26, 2011 9:40 AM
To: Mcleod, John
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pgsql error

On Tue, Jul 26, 2011 at 7:47 AM, Mcleod, John <johnm(at)spicergroup(dot)com> wrote:
> Thank you for the reply.
>
> At command line, I ran...
> "psql  --version"
> and received..
> "psql  (PostgreSQL) 7.5devel"
>
> The database is sitting on a Windows 2003 Server box.
> A mapping application, wrote in PHP, runs with Apache 2.05

ok -- first you reported the version # of the client, not the back end. let's hope they are different. you are running an early development build of postgres 8.0 -- I know this because about 3/4 the way through the development cycle the version # changed from 7.5 to 8.0. This is essentially a completely unpactched, riddled with known bugs, alpha build. Prevailing wisdom is that the earliest good build to use on windows is 8.2 or maybe 8.3.

Right now 100% of your energy should be devoted to double checking the version# against the backend (postgres -- version) and, if it is also
7.5 devel, capturing a good backup if you don't have one already and upgrading ASAP.

merlin