1回答
- 新しい順
- 投票が多い順
- コメントが多い順
1
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
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 1年前
- AWS公式更新しました 2年前
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?