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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026