I have two servers on the same network which I have live streaming with a master-slave structure. I'm not using any tools like Slony or Bucardo. It's a simple replication process that can be accomplished by changing some parameters in the .conf files. Curently it can accept read/write on the master and read-only on the slave. However I want a master-master structure, wherein both the servers can accept read as well as write requests. Is this possible in PostgreSQL 9.3 or above?
Is it possible to provide write permissions for slave/standby servers in postgresql in a cluster?
4k views Asked by Caroffrey At
2
There are 2 answers
0
SCO
On
As far as I known, multimaster is not available in the vanilla flavour of PostgreSQL. Did you check Postgres-XC or Postgres Plus ?
[http://postgresxc.wikia.com/wiki/Postgres-XC_Wiki][1]
[http://www.enterprisedb.com/products-services-training/products/postgres-plus-advanced-server][2]
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in CLUSTER-COMPUTING
- How to Socket.IO Multithreading on a Raspberry Pi?
- Snakemake remote rules re-read config file?
- Why can CPU memory be specified and allocated during instance creation but not GPU memory on the cloud?
- Make a Cluster without using MongoDB Atlas
- Why don't run at multiple thread?
- Imports failing with workaround in Google Dataproc Cluster Notebooks
- Galera Cluster: 3 Node Cluster, One Node does not reconnect after rebooting
- How to install gromacs on gcp HPC
- Slurm - How to run a list of jobs n by n?
- Setup Slurm partition for only interactive jobs
- makeCluster fails with remote server Ubuntu
- Creating a cluster with two laptops (mac)
- How to configure express-fileupload with cluster?
- problem in configuring dataproc cluster from GCP Console since Friday (1 february 2024)
- Kubernetes cluster refused to connect google cloud
Related Questions in REPLICATION
- Which column to use for ordering change data read from change tables in SQL Server?
- Postgresql Database Replicate Using Docker-Compose File
- PG_chameleon during start replica turns columns into UNKNOWN_COL{number}
- Consistency of replicated map across cluster nodes
- DB Replicating from different publisher to a sing subscriber
- How to route different db requests to read only instance
- Replication postgresql database error connection between master to standby
- mongodb statefulset pods restarting without any useful error during replication
- Snapshots in Logical Decoding
- SQL Server replication: Need to remove articles from the publication
- TSQL query for transactional replication log reader agent account in SQL Server
- Does PostgresSQL 16 support Active Active replication ? I am using the free version
- Invoke-Command to a DC for replication not working in Windows 11
- Postgres connection failed while Debezium connector streaming changes
- How to Achieve Master-Master Replication in MongoDB for Two Databases in Different Locations?
Related Questions in MASTER-SLAVE
- STM32 SPI slave doesn't read data correctly and transmits incorrect data
- First mysql docker containers restarting when a second mysql container is started
- Latency when backup becomes primary
- Changing binlog_format in MariaDB slave
- failover-abort-no-good-slave error in Redis-Sentinel auto failover
- Execute a function every 10 ms with also some offset and random jitter
- How does data reading works in redis in terms of master slave server
- Cloudera configuration between Master and Slave Nodes
- How to run two Java versions on same jenkins slave
- how to use redline in jmeter master-slave
- In distributed jmeter load testing, got stuck at 'Waiting for possible shutdown message on port 4445'
- Is any solution related to SparkConnectGrpcException?
- What is the meaning of Slave Offset and how is this term defined in plc programming context?
- How to test load-balancer of MaxScale
- RedBean PHP for master/slave MYSQL databases
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
No.
So, PostgreSQL's built-in streaming replication.
There's an extension for PostgreSQL 9.4 that adds multi-master, called BDR. See http://bdr-project.org/docs/stable/ and http://2ndquadrant.com/BDR . It's not really ready for widespread adoption by new database users though - you should be pretty confident with PostgreSQL and replication if you're going to use it at this point. (Note: I'm one of the developers of BDR). BDR is asynchronous multi-master replication, it's not transparent clustering that you can just point an existing app at and expect it to work without changes. See the manual for details.
There is also Postgres-XC and its fork Postgres-XL, which add tightly coupled multi-master clustering and parallel dispatch to PostgreSQL. Apps may require fewer changes to run on XC, but it requires fast, reliably, low-latency networking between nodes.
There are other options like a multi-master variant of Slony-I, the Bucardo project, etc.
All of these share some common details: it's really, really important to know what you're doing and what the exact limitations, caveats and special cases with the multi-master implementation you have chosen are. If you just go ahead and deploy an app pointing at multiple masters without careful thought and testing you are going to have some sleepless weekends and angry users.
That's before you even get into disaster recovery planning, failover, backup management, etc.
If you do not know that you absolutely need multi-master, then do not use it.