Unlogged Aurora PostgreSQL tables and read replicas

Question

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

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

Unlogged Aurora PostgreSQL tables and read replicas

Conteúdo relevante