Обсуждение: *Old* PostgreSQL version

Поиск
Список
Период
Сортировка

*Old* PostgreSQL version

От
Alex Shnitman
Дата:
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

Re: [GENERAL] *Old* PostgreSQL version

От
Bruce Momjian
Дата:
> 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

Re: [GENERAL] *Old* PostgreSQL version

От
Remigiusz Sokolowski
Дата:
> 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           * *
-----------------------------------------------------------------*****----------


Re: [GENERAL] *Old* PostgreSQL version

От
Alex Shnitman
Дата:
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.

Re: [GENERAL] *Old* PostgreSQL version

От
Bruce Momjian
Дата:
> 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

Re: [GENERAL] *Old* PostgreSQL version

От
Alex Shnitman
Дата:
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

От
ralli@poboxes.com
Дата:
unsubscribe



Re: [GENERAL] *Old* PostgreSQL version

От
Herouth Maoz
Дата:
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