By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Unlogged Aurora PostgreSQL tables and read replicas

0

When setting an Aurora RDS PostgreSQL table to unlogged, will those unlogged tables still be available in read replicas?

Topics
Database
Tags
Aurora PostgreSQL
Language
English
rePost-User-4634955
asked a year ago1.1K views
1 Answer
1
Accepted Answer

Hi, you probably guessed the answer when you asked the question: the answer is no and for the clear reason that unlogged table means no existing logs to send to read replicas.

Confirmed by https://aws.amazon.com/blogs/database/understand-replication-capabilities-in-amazon-aurora-postgresql/

The UNLOGGED and TEMPORARY tables aren’t replicated, much like with physical replication.
 This is because the changes to these tables don’t have entries in the transaction logs 
(Write-Ahead Logs), and it’s impossible for the logical worker process to capture the changes 
happening on these tables.

Best, Didier

profile pictureAWS
EXPERT
Didier_Durand
answered a year ago
  • Ashish
    a year ago

    Hi Didier, We were able to query 'UNLOGGED' tables from read replica till Aurora Postgres version 12.12. But they are not available after upgrade to 13.10.

    How come they were available on read replica prior to version 12.12? Is it a change that was implemented within Aurora Postgres 13.10?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content