Re: [GENERAL] *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