Thread: *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? Thanks! -- 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
> 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. -- 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: > > > > 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: > > > 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
unsubscribe
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