Answer the question
In order to leave comments, you need to log in
postgres. How to create a READ/WRITE table on a Slave machine (Replication)?
Hello! I set up a replica of the postgres database according to the instructions https://www.8host.com/blog/replikaciya-baz-dannyx-...
Now it became necessary to create a table on the Slave machine in the same database, into which the slave could make inserts. How is this possible? When I try to create a table, I get an error:
ERROR: cannot execute CREATE TABLE in a read-only transaction
Answer the question
In order to leave comments, you need to log in
This cannot be done on a slave.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question