Обсуждение: BUG #14269: Postgres JDBC driver should be able to connect using protocol version 2 to server versions 9.5+
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI2OQpMb2dnZWQgYnk6ICAg ICAgICAgIGtoCkVtYWlsIGFkZHJlc3M6ICAgICAga2gyQGFyYXhpcy5jb20K UG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMwpPcGVyYXRpbmcgc3lzdGVtOiAg IEZyZWVCU0QgMTAuMy1SRUxFQVNFLXA2CkRlc2NyaXB0aW9uOiAgICAgICAg CgpXaXRoIHRoZSByZWxlYXNlIG9mIFBvc3RncmVTUUwgOS41LjAsIHN1cHBv cnQgZm9yIHRoZSBzZXJ2ZXIgY29uZmlndXJhdGlvbgpwYXJhbWV0ZXIgImF1 dG9jb21taXQiIGhhcyBiZWVuIHJlbW92ZWQgKGFzIGRldGFpbGVkIGluIHRo ZSByZWxlYXNlIG5vdGVzCmZvciA5LjUuMCkuIFJlbW92YWwgb2YgdGhpcyBz dXBwb3J0IHByZXZlbnRzIGNvbm5lY3Rpb25zIHdpdGggdGhlIGFsbCByZWNl bnQKdmVyc2lvbnMgb2YgdGhlIFBvc3RncmVzcWwgSkRCQyBkcml2ZXIgdXNp bmcgSkRCQyBwcm90b2NvbCB2ZXJzaW9uIDIuDQoNCkF0dGVtcHRpbmcgdG8g dXNlIHByb3RvY29sIHZlcnNpb24gMiB0byBjb25uZWN0IHRvIFBvc3RncmVz IHNlcnZlcnMgdjkuNSBhbmQKbGF0ZXIsIHJlc3VsdHMgaW4gYW4gcG9zdGdy ZXNxbCBzZXJ2ZXIgbG9nIGVudHJ5Og0KDQpFUlJPUjogIHVucmVjb2duaXpl ZCBjb25maWd1cmF0aW9uIHBhcmFtZXRlciAiYXV0b2NvbW1pdCINClNUQVRF TUVOVDogIGJlZ2luOyBzZXQgYXV0b2NvbW1pdCA9IG9uOyBzZXQgY2xpZW50 X2VuY29kaW5nID0gJ1VURjgnOyBTRVQKZXh0cmFfZmxvYXRfZGlnaXRzPTM7 IGNvbW1pdA0KDQpUaGUgc291cmNlIG9mIHRoZSBlcnJvciBpcyB0aGUgcnVu SW5pdGlhbFF1ZXJpZXMoKSBtZXRob2Qgb2YKb3JnLnBvc3RncmVzcWwuY29y ZS52Mi5Db25uZWN0aW9uRmFjdG9yeUltcGwuamF2YSB3aGVyZSwgb24gbGlu ZSA0MzEgKHRha2VuCmZyb20gdmVyc2lvbiAxMjA5IG9mIHRoZSBwb3N0Z3Jl YXFsIEpEQkMgZHJpdmVyIHNvdXJjZSksIGFueSBjb25uZWN0aW9uIHRvIGEK c2VydmVyIHZlcnNpb24gNy4zIG9yIGhpZ2hlciBydW5zIHRoZSBTUUwgZ2l2 ZW4gaW4gdGhlIHN0YXRlbWVudCBhYm92ZS4NCg0KQ2xlYXJseSwgaWYgdGhl IEpEQkMgZHJpdmVyIGlzIHRvIGNvbnRpbnVlIHRvIHN1cHBvcnQgcHJvdG9j b2wgdmVyc2lvbiAyLCBpdApzaG91bGQgbm90IGJlIHRyeWluZyB0byBzZXQg c2VydmVyIGNvbmZpZ3VyYXRpb24gcGFyYW1ldGVycyB0aGF0IGRvIG5vdApl eGlzdCBvbiB0aGUgc2VydmVyIDkuNSBhbmQgbGF0ZXIsIGNhdXNpbmcgYSBj b25uZWN0aW9uIHRvIGZhaWwuCgo=
Re: BUG #14269: Postgres JDBC driver should be able to connect using protocol version 2 to server versions 9.5+
От
"David G. Johnston"
Дата:
On Fri, Jul 29, 2016 at 9:34 AM, <kh2@araxis.com> wrote: > The following bug has been logged on the website: > > Bug reference: 14269 > Logged by: kh > Email address: kh2@araxis.com > PostgreSQL version: 9.5.3 > Operating system: FreeBSD 10.3-RELEASE-p6 > Description: > =E2=80=8B[...] =E2=80=8B > > Clearly, if the JDBC driver is to continue to support protocol version 2, > it > should not be trying to set server configuration parameters that do not > exist on the server 9.5 and later, causing a connection to fail. > =E2=80=8BNot our (PostgreSQL's) bug...its JDBC's. =E2=80=8Bhttps://github.com/pgjdbc/pgjdbc/issues We are well within our rights to remove configuration parameters in new versions. If you do post an issue against the JDBC driver it would be nice to know why you are trying to connect to a version 9.5 server using an outdated protocol version. This has already come up and a PR was opened: https://github.com/pgjdbc/pgjdbc/pull/581 See additional discussion therein. In addition to GitHub JDBC-related discussions also happen on: pgsql-jdbc@postgresql.org David J.