Amazon Web Services Question posted in
The official Amazon Web Services documentation can be found here.

Amazon web services – aws rds version

Is it possible to get aws rds version?

I know for Aws rds Aurora version

select aurora_version();
 aurora_version 
----------------
 16.3.0
(1 row)

 select version();
                                                   version                                                   
-------------------------------------------------------------------------------------------------------------
 PostgreSQL 16.3 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit
(1 row)

 SHOW server_version
 server_version 
----------------
 16.3
(1 row)

but I want to know the rds version().
and anyone know where aurora_version() is stored in catalog?

My main concern is to distinguish between the 2 instance aurora and rds. One instance create with aurora PostgreSQL and other one normal RDS PostgreSQL, by running select aurora_version(); I can say that this aurora instance on success!. like I want to confirm RDS(not aurora) instance.

Tags:

2

Answers


  1. 0

    i had to answer you in answer section becasue OP was deniying the command SELECT version(); not getting the postgres version and i could not paste the proof in comment.
    i created posgres rds and connected to it and run the command,
    so here is the proof, here you go:

    enter image description here

    Login or Signup to reply.
  2. 0

    Let’s focus on addressing your concern which is to distinguish between the 2 instance Aurora Postgres and RDS Postgres since there is nothing like rds_version

    do $$
declare
v_ver varchar(10);
begin
select aurora_version() into v_ver; 
raise notice '%',v_ver;
exception 
    when others then
    raise notice 'It''s RDS Postgres';
end;
$$;

    Above script will always give result for Aurora postgres and will always fail for RDS(will always execute exception block).

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search