*Old* PostgreSQL version

Hi!

I read in the FAQ that in order to find out the version of PostgreSQL
I'm running I have to so "select version();" from psql. I have a very
old installation of PostgreSQL that I need to upgrade, so I need to
find out its version, but this trick doesn't work:

database_name=> select version();
WARN:parser: Syntax error at or near "version"

What else can I do? I can see from the dates of the files that it was
installed sometime in mid-1997. What else can I use to find the
version?

That's a good one. There is a data/PG_VERSION file in the install
directory that should contain the version, though there was one release
where we forgot to update that. That may help. I assume you don't have
the source code, because the HISTORY file always has the version at the
top of the file.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Hi!

I read in the FAQ that in order to find out the version of PostgreSQL
I'm running I have to so "select version();" from psql. I have a very
old installation of PostgreSQL that I need to upgrade, so I need to
find out its version, but this trick doesn't work:

database_name=> select version();
WARN:parser: Syntax error at or near "version"

What else can I do? I can see from the dates of the files that it was
installed sometime in mid-1997. What else can I use to find the
version?

AFAIK
in database system directory there is some file with name PG_VERSION -
maybe this way You can find out what version You use.
But I have 6.3.2 version, and don't know if this file is in older versions
Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * *
-----------------------------------------------------------------*****----------

Bruce Momjian writes:

database_name=> select version();
WARN:parser: Syntax error at or near "version"

What else can I do? I can see from the dates of the files that it was
installed sometime in mid-1997. What else can I use to find the
version?

That's a good one. There is a data/PG_VERSION file in the install
directory that should contain the version, though there was one release
where we forgot to update that. That may help. I assume you don't have
the source code, because the HISTORY file always has the version at the
top of the file.

Yes, that did it! Thanks a lot. (6.1... Not *that* old after all. Or
is it?) Perhaps it needs to be added to that question in the FAQ or
something.

Well, now that we have version(), we hope it will be easier for people.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian writes:

database_name=> select version();
WARN:parser: Syntax error at or near "version"

What else can I do? I can see from the dates of the files that it was
installed sometime in mid-1997. What else can I use to find the
version?

That's a good one. There is a data/PG_VERSION file in the install
directory that should contain the version, though there was one release
where we forgot to update that. That may help. I assume you don't have
the source code, because the HISTORY file always has the version at the
top of the file.

Yes, that did it! Thanks a lot. (6.1... Not *that* old after all. Or
is it?) Perhaps it needs to be added to that question in the FAQ or
something.

--
Alex Shnitman | http://www.debian.org
alexsh@hectic.net, alexsh@linux.org.il +-----------------------
http://alexsh.hectic.net UIN 188956 PGP key on web page
E1 F2 7B 6C A0 31 80 28 63 B8 02 BA 65 C7 8B BA

Minds are like parachutes... they work best when open.

Bruce Momjian writes:

That's a good one. There is a data/PG_VERSION file in the install
directory that should contain the version, though there was one release
where we forgot to update that. That may help. I assume you don't have
the source code, because the HISTORY file always has the version at the
top of the file.

Yes, that did it! Thanks a lot. (6.1... Not *that* old after all. Or
is it?) Perhaps it needs to be added to that question in the FAQ or
something.

Well, now that we have version(), we hope it will be easier for people.

Sure, but the idea is that people want to check out *old* versions of
the software, and version() wans't there always.

--
Alex Shnitman | http://www.debian.org
alexsh@hectic.net, alexsh@linux.org.il +-----------------------
http://alexsh.hectic.net UIN 188956 PGP key on web page
E1 F2 7B 6C A0 31 80 28 63 B8 02 BA 65 C7 8B BA

At 16:37 +0300 on 25/06/1999, Alex Shnitman wrote:

Yes, that did it! Thanks a lot. (6.1... Not *that* old after all. Or
is it?) Perhaps it needs to be added to that question in the FAQ or
something.

Watch out - 6.2.x were also marked as 6.1, and weren't 6.1.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma