logo

Postgres Tools and Features in RDS from the perspective of an Oracle DBA | S01 E26 | Lets Talk About Data Show

We have 3 Guests from CDL softward sharing with us the tools and features they use in PostgeSQL RDS with a view from moving from Oracle with a DBA perspective

Prasad Matkar
Prasad Matkar
Amazon Employee
Tony Mullen
Tony Mullen
Amazon Employee
Published Oct 18, 2023

Screenshot from the stream or an image related to the topic

In this episode of Lets Talk About Data we discuss with 3 Guests from CDL softward sharing with us the tools and features they use in PostgeSQL RDS with a view from moving from Oracle with a DBA perspective.

Check out the recording here:

Tony Mullen, Senior RDS Specialist Solutions Architect @ AWS

Daniel Chapman, Lead Cloud Database Engineer at CDL Software Lauro Ojeda, Sr. Cloud Database Engineer at CDL Software Jade Buckingham(https://www.linkedin.com/in/jade-buckingham/), Technical Delivery Lead at CDL Software

  • psql download - https://www.postgresql.org/download/
  • pgadmin- https://www.pgadmin.org/
  • pgdump example - https://www.postgresql.org/docs/current/app-pgdump.html
  • pg_transport - https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/transport-postgresql-databases-between-two-amazon-rds-db-instances-using-pg_transport.html
  • pgbench - swingbench example - https://www.postgresql.org/docs/current/pgbench.html
  • pg_stat_statements - https://www.postgresql.org/docs/current/pgstatstatements.html
  • pgbadger - https://github.com/darold/pgbadger
  • partitioning - https://www.postgresql.org/docs/current/ddl-partitioning.html
  • auditing - https://www.pgaudit.org/

  • Tony: (https://www.linkedin.com/in/tony-mullen-8b05927d/)
  • Daniel: (https://www.linkedin.com/in/daniel-chapman-a753b56b/)
  • Lauro: (https://www.linkedin.com/in/lauro-fabiano-ojeda-00b5b54/)
  • Jade: (https://www.linkedin.com/in/jade-buckingham/)