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 best solutions below
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
- Why does adding a JOIN completely modify the query planner behaviour?
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Aggregate and count in PostgreSQL
- Rails HABTM: Select everything a that a record 'has'
- Trigger using data from inserted row
- Select results where joined table contains records with an attribute, but without another
- DB candidate as CouchDB/Schema replacement
- How do I properly add data in SQLAlchemy?
- Postgres in Conda Environment (Ubuntu 14.04)
- How to customize the output of the Postgres Pseudo Encrypt function?
- Split a large query (2 days) into pieces to increase the speed in Postgres
- Why does pg_search prefix not work like I expect?
- extracting meta info from a table psql using information_schema
- How to query a table in the database and copy it's data into one one?
- Update a table using info from a second table and a condition from a third table in Postgresql
Related Questions in CLUSTER-COMPUTING
- What clustering algorithms can I consider for graph?
- SQL Server 2012 or 2014 Failover Cluster - Change Instance Port Number
- Scatter 2D coordinates from distance matrix
- Forwarding signals in bash script which is submitted on the cluster
- How to deploy three config server instances for sharding in mongodb?
- do I need to restart ALL the hadoop daemons whenever I make changes to xml configuration files
- pbs python Error: No module named _pbs
- Predis: Pros and Cons of the two cluster strategies
- Hadoop NameNode does not start
- does redis cluster support transactions ？
- Best Practice for synchronized jobs in Application clusters
- Quartz scheduler with percona db cluster giving deadlock errors
- Running Batch Job on Slurm Cluster
- jdbc backed channel on a cluster mode
- How to run Cron Job in Node.js application that uses cluster module?
Related Questions in REPLICATION
- How to handle sequences in Bucardo Postgresql multi master
- percona replication -slave does not follow the master
- sql server for replication and web application
- does slave-skip-errors avoid remove errors from the logs
- MySQL Replication tables needed to be replicated is working except for 2 tables
- Cancel DELETE on MySQL REPLICATE
- How to fix jobs conflict in transactional replication
- Trigger to update a table when data in other table is updated
- Replicating Master-slave on mysql using gtid in mysql-5.6
- Where I can find MariaDB protocol document that different from MySQL
- Create Trigger does not replicate in mysql
- How to delete replication slot in postgres 9.4
- Performance/Latency when using mysql replication
- What connection string to use for Azure SQL DB using Active Geo Replication?
- how hdfs removes over-replicated blocks
Related Questions in MASTER-SLAVE
- Deployment of multiple Jenkins slaves on a Mac
- percona replication -slave does not follow the master
- does slave-skip-errors avoid remove errors from the logs
- Stm32f407IG SPI communication
- Jenkins jobs running on slaves
- Jenkins jobs configuration checking before run it
- Is it a bad idea to use a web api instead of a tcp socket for master/slave communication?
- Sync two FPGAs to generate same Sine Wave
- Is it possible to provide write permissions for slave/standby servers in postgresql in a cluster?
- Switch MySQL slave to master - BINLOG_FORMAT
- How to know the input buffer of the serial port has information, in C#?
- MySQL poor performance in Centos 7
- Build Apache Hadoop 2.5.1 in windows
- MySQL Master-Slave Replication "Unknown database" error
- Dealing with Master-Slave (MySQL) Replication Delay with Symfony2
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)
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?
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.