At work we're thinking about adding a Postgresql replica.

We were wondering whether it's possible to create views and materialised views directly on the replica.

1 Answer 1


If you are using streaming replication, no, because the replica is read-only.

If you are using logical replication, yes.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.