sql_implementation_info still contains old value
I noticed this in information_schema; it would seem
the 'DBMS VERSION' is still the old value:
$ psql
psql (9.2.1)
Type "help" for help.
# select version();
version
-----------------------------------------------------------------------------------
PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.6.2, 64-bit
(1 row)
# select *
from information_schema.sql_implementation_info
where implementation_info_name = 'DBMS VERSION';
-[ RECORD 1 ]------------+-------------
implementation_info_id | 18
implementation_info_name | DBMS VERSION
integer_value |
character_value | 09.02.0000
comments |
I would expect 9.2.1 to contain '09.02.0001' (not '09.02.0000').
Unless, of course, I have overlooked some step in the upgrade...
Thanks,
Erik Rijkers
On 25-10-2012 15:36, Erik Rijkers wrote:
I would expect 9.2.1 to contain '09.02.0001' (not '09.02.0000').
'09.02.0000' is the initdb'ed version. It seems you upgrade binaries from 9.2
to 9.2.1.
euler=# select version();
version
----------------------------------------------------------------------------------------------
PostgreSQL 9.1.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.1-7) 4.7.1, 64-bit
(1 registro)
euler=# select implementation_info_name,character_value from
information_schema.sql_implementation_info where implementation_info_name =
'DBMS VERSION';
implementation_info_name | character_value
--------------------------+-----------------
DBMS VERSION | 09.01.0002
(1 registro)
It seems we should ignore the last digit or invent a way to update that tuple
according to the new minor version. Another option is document that that
version is the initdb'ed version.
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-
owner@postgresql.org] On Behalf Of Euler Taveira
Sent: Thursday, October 25, 2012 6:59 PM
To: Erik Rijkers
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] sql_implementation_info still contains old valueOn 25-10-2012 15:36, Erik Rijkers wrote:
I would expect 9.2.1 to contain '09.02.0001' (not '09.02.0000').
'09.02.0000' is the initdb'ed version. It seems you upgrade binaries from
9.2
to 9.2.1.
It seems we should ignore the last digit or invent a way to update that
tuple
according to the new minor version. Another option is document that that
version is the initdb'ed version.
If this is the case does pg_upgrade "init-db" for this purpose?
David J.
On 25-10-2012 21:05, David Johnston wrote:
If this is the case does pg_upgrade "init-db" for this purpose?
Yes.
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento