>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.
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.