You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2023/01/11 07:55:03 UTC

[GitHub] [shardingsphere] LanceJerry opened a new issue, #23501: When postgresql node use db-discovery, choose which discoveryType?

LanceJerry opened a new issue, #23501:
URL: https://github.com/apache/shardingsphere/issues/23501

   ## Question
   
   **postgresql db use shardingsphere-porxy**, we plan to choose db-discovery and RW splitting to complete dynamic RW splitting.
   
   there are three discovery types:
   
   - MySQL.MGR,
   - MySQL.NORMAL_REPLICATION
   - openGauss.NORMAL_REPLICATION
   
   **which discoveryType could used by postgresql?** we tried openGauss.NORMAL_REPLICATION and get a error result,, it seems not be suitable to postgresql. there are errors:
   
   - o.a.s.d.a.DatabaseDiscoveryEngine - Load data source replica status error: 
   org.postgresql.util.PSQLException: ERROR: function pg_stat_get_stream_replications() does not exist
   建议：No function matches the given name and argument types. You might need to add explicit type casts.
   
   


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] LanceJerry commented on issue #23501: When postgresql node use db-discovery, choose which discoveryType?

Posted by GitBox <gi...@apache.org>.
LanceJerry commented on issue #23501:
URL: https://github.com/apache/shardingsphere/issues/23501#issuecomment-1380073689

   > Sorry, PostgreSQL db-discovery is not currently supported, if you have a good implementation, welcome to submit a PR.
   
   Thanks for your reply, we will try to resolve it.


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] When postgresql node use db-discovery, choose which discoveryType? [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #23501:
URL: https://github.com/apache/shardingsphere/issues/23501#issuecomment-2212314586

   The database discovery feature has been remove form ShardingSphere, please ref #24486


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] LanceJerry commented on issue #23501: When postgresql node use db-discovery, choose which discoveryType?

Posted by GitBox <gi...@apache.org>.
LanceJerry commented on issue #23501:
URL: https://github.com/apache/shardingsphere/issues/23501#issuecomment-1378437201

   shardingsphere-proxy version：5.3.2


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] Pace2Car commented on issue #23501: When postgresql node use db-discovery, choose which discoveryType?

Posted by GitBox <gi...@apache.org>.
Pace2Car commented on issue #23501:
URL: https://github.com/apache/shardingsphere/issues/23501#issuecomment-1378460899

   Sorry, PostgreSQL db-discovery is not currently supported, if you have a good implementation, welcome to submit a PR.


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on issue #23501: When postgresql node use db-discovery, choose which discoveryType?

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #23501:
URL: https://github.com/apache/shardingsphere/issues/23501#issuecomment-1407559429

   Hi @LanceJerry , Do you want to submit a PR?


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] When postgresql node use db-discovery, choose which discoveryType? [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #23501: When postgresql node use db-discovery, choose which discoveryType?
URL: https://github.com/apache/shardingsphere/issues/23501


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org