What is the aurora_server_id (mysql) variable alternative for postgresql?

Question

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.

Answer

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!

What is the aurora_server_id (mysql) variable alternative for postgresql?

Relevanter Inhalt