sandynz commented on issue #6943: URL: https://github.com/apache/shardingsphere/issues/6943#issuecomment-677197429
> > > @sandynz Hi thanks for your issue and PR. Just to confirm, you can not install the ShardingSphere project due to the configuration for PostgreSQL? > But Sorry, I can not get the point from your PR. How could an added` SQL case` solve your issue? Hi @tristaZero , I was running DCL integration test these days, it blocked by this issue, since `postgresql.password` was changed by test case, then the later jdbc connection could not be created, and integration test broken. Related env.properties configurations: ``` postgresql.host=127.0.0.1 postgresql.port=5432 postgresql.username=postgres postgresql.password=test ``` This test case is: `<dcl-test-case sql="ALTER USER CURRENT_USER WITH ENCRYPTED PASSWORD 'password'" db-types="PostgreSQL"/>`. I think it could be removed, this situation could be tested by: `<dcl-test-case sql="ALTER USER user_dev WITH ENCRYPTED PASSWORD 'password'" db-types="PostgreSQL"/>`. `ALTER PASSWORD` could be verified with psql on command line: - run `psql -U postgres`, enter original password, e.g. `test` - run `ALTER USER CURRENT_USER WITH ENCRYPTED PASSWORD 'password'` - run `\q` - run `psql -U postgres`, password should be `password` now ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
