Jasmin shahrzad
asked on
master/slave operation
i have 2 ubuntu server with postgres10.
I try to create master slave (second read only) database
i used doc: https://www.howtoforge.com/tutorial/how-to-set-up-master-slave-replication-for-postgresql-96-on-ubuntu-1604/
its working at the first time.
slave is crash disk i install a new one same ip and same procedure (after documentation. now i have 2 master.
I try to create master slave (second read only) database
i used doc: https://www.howtoforge.com/tutorial/how-to-set-up-master-slave-replication-for-postgresql-96-on-ubuntu-1604/
its working at the first time.
slave is crash disk i install a new one same ip and same procedure (after documentation. now i have 2 master.
ASKER
i mean master/slave replication.
I try to create a new server (slave ) and i replicate all databases in new (slave) server. Then the new one it must be a read-only database. but it's not. it's working like a master database.
I try to create a new server (slave ) and i replicate all databases in new (slave) server. Then the new one it must be a read-only database. but it's not. it's working like a master database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes i did. it working now i forgot the line standby_mode and chmod 600 on the recovery.conf file.
Thank you. Arnold
Thank you. Arnold
or you mean that the procedure failed, and effectively each has their own database in read-write, no replication?