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@xxxxxxxxx] Sent: Tuesday, July 26, 2011 9:40 AM To: Mcleod, John Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: pgsql error On Tue, Jul 26, 2011 at 7:47 AM, Mcleod, John <johnm@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
