Обсуждение: Using 9.6 client with 10.0 server

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

Using 9.6 client with 10.0 server

От
Ronnj Grotto
Дата:

Hello,

are there any drawbacks in using 9.6 client with 10.0 server?

Thank you in advance.

 

Ronnj Grotto
DATABASE ADMIN
ronnj.grotto@texa.com
Diretto: 0422.79.16.85
Interno: 1685

  

TEXA S.p.A.
Sede Legale: Via 1 Maggio, 9 - 31050 Monastier di Treviso - ITALY
Stabilimento e Sede Amministrativa: Via Vallio - 31050 Monastier di Treviso - ITALY
Cod. Fisc.- N.I. Registro Imprese di Treviso - Part. IVA: 02413550266
Capitale Sociale 1.000.000 € i.v. - R.E.A. N. 208102
Società con socio unico e soggetta ad attività di direzione e coordinamento di Opera Holding S.r.l.
Phone +39 0422.791.311
Fax +39 0422.791.300
www.texa.com

CONFIDENTIALITY NOTICE
This message and its attachments are addressed solely to the persons above and may contain confidential information.
If you have received the message in error, be informed that any use of the content here of is prohibited.
Please return it immediately to the sender and delete the message.
P Please consider the environment before printing this e-mail.

 

Вложения

Re: Using 9.6 client with 10.0 server

От
Shreeyansh Dba
Дата:


On Thu, Jan 11, 2018 at 3:44 PM, Ronnj Grotto <ronnj.grotto@texa.com> wrote:

Hello,

are there any drawbacks in using 9.6 client with 10.0 server?


​The only utilities "psql and pgadmin" of 9.6​ can be used with 10.0 server, but the rest of all utilities cannot be used with 10.0. server

Thank you in advance.

 

Ronnj Grotto
DATABASE ADMIN
ronnj.grotto@texa.com
Diretto: 0422.79.16.85
Interno: 1685

  

TEXA S.p.A.
Sede Legale: Via 1 Maggio, 9 - 31050 Monastier di Treviso - ITALY
Stabilimento e Sede Amministrativa: Via Vallio - 31050 Monastier di Treviso - ITALY
Cod. Fisc.- N.I. Registro Imprese di Treviso - Part. IVA: 02413550266
Capitale Sociale 1.000.000 € i.v. - R.E.A. N. 208102
Società con socio unico e soggetta ad attività di direzione e coordinamento di Opera Holding S.r.l.
Phone +39 0422.791.311
Fax +39 0422.791.300
www.texa.com

CONFIDENTIALITY NOTICE
This message and its attachments are addressed solely to the persons above and may contain confidential information.
If you have received the message in error, be informed that any use of the content here of is prohibited.
Please return it immediately to the sender and delete the message.
P Please consider the environment before printing this e-mail.

 




--
http://www.shreeyansh.com
Вложения

RE: Using 9.6 client with 10.0 server

От
Ronnj Grotto
Дата:

Thank you Shreeyansh!

Do you know anything about libraries?

In particular libpq (v9.6 towards v10.0).

Thanks.

 

 

 

From: Shreeyansh Dba [mailto:shreeyansh2014@gmail.com]
Sent: giovedì 11 gennaio 2018 11:34
To: Ronnj Grotto <ronnj.grotto@texa.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Using 9.6 client with 10.0 server

 

 

 

On Thu, Jan 11, 2018 at 3:44 PM, Ronnj Grotto <ronnj.grotto@texa.com> wrote:

 

Hello,

are there any drawbacks in using 9.6 client with 10.0 server?

 

​The only utilities "psql and pgadmin" of 9.6​ can be used with 10.0 server, but the rest of all utilities cannot be used with 10.0. server

 

Thank you in advance.

/media/maillist_attaches/pgsql-admin/2018/01/11/AM4PR04MB21612175EDB8CBC7540239D1F1160@AM4PR04MB2161.eurprd04.prod.outlook.com/image002.jpg

 



 

--

 

Вложения

Re: Using 9.6 client with 10.0 server

От
Imre Samu
Дата:
>are there any drawbacks in using 9.6 client with 10.0 server?

imho:   you have to  re-check the new improvements[1] :
some examples:
* "Declarative table partitioning"   (  as I know,  you can't see all information from psql9.6 ) 
* "Stronger password authentication based on SCRAM-SHA-256"   ( if the security is the first priority )
scram-sha-256
The method scram-sha-256performs SCRAM-SHA-256 authentication, as described in RFC 7677. It is a challenge-response scheme that prevents password sniffing on untrusted connections and supports storing passwords on the server in a cryptographically hashed form that is thought to be secure.
This is the most secure of the currently provided methods, but it is not supported by older client libraries.
* changes in sequences  (  "a new pg_sequence system catalog" ; "The output of psql's \d command for a sequence has been redesigned, too."   )
* changes in "psql"  Client Application

 Imre


2018-01-11 11:14 GMT+01:00 Ronnj Grotto <ronnj.grotto@texa.com>:

Hello,

are there any drawbacks in using 9.6 client with 10.0 server?

Thank you in advance.

 

Ronnj Grotto
DATABASE ADMIN
ronnj.grotto@texa.com
Diretto: 0422.79.16.85
Interno: 1685

  

TEXA S.p.A.
Sede Legale: Via 1 Maggio, 9 - 31050 Monastier di Treviso - ITALY
Stabilimento e Sede Amministrativa: Via Vallio - 31050 Monastier di Treviso - ITALY
Cod. Fisc.- N.I. Registro Imprese di Treviso - Part. IVA: 02413550266
Capitale Sociale 1.000.000 € i.v. - R.E.A. N. 208102
Società con socio unico e soggetta ad attività di direzione e coordinamento di Opera Holding S.r.l.
Phone +39 0422.791.311
Fax +39 0422.791.300
www.texa.com

CONFIDENTIALITY NOTICE
This message and its attachments are addressed solely to the persons above and may contain confidential information.
If you have received the message in error, be informed that any use of the content here of is prohibited.
Please return it immediately to the sender and delete the message.
P Please consider the environment before printing this e-mail.

 


Вложения

Re: Using 9.6 client with 10.0 server

От
Alvaro Herrera
Дата:
Imre Samu wrote:

> * changes in sequences  (  "a new pg_sequence system catalog" ; *"The
> output of psql's \d command for a sequence has been redesigned, too." *  )
> * changes in "psql"  Client Application

Note that psql is purposefully kept compatible with previous server
versions, so it should work without issue.  If it does not, please
report it as a bug.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services