What is the aurora_server_id (mysql) variable alternative for postgresql?
Looking for a way to get the database instance name for the current session in postgresql, just like the variable "aurora_server_id" did in mysql. When running commands, there needs to be a way to verify that we are connected to the host we think we are connected to. "inet_server_addr" gives IP but we want to know the instance name.
- 최신
- 최다 투표
- 가장 많은 댓글
Hello,
Thanks for reaching out to AWS re:Post.
First of all, I would like to apologize for the delay in response to this post. I saw the query just now and started diving deeper on it.
Please note that Aurora Postgresql does not have an equivalent to "aurora_server_id". That being said-> You can use the below command to get details about your connection
SELECT * FROM aurora_replica_status()
I sincerely hope this helps in your project - Have a great rest of the day!
