Link to home
Start Free TrialLog in
Avatar of Jasmin shahrzad
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.
Avatar of arnold
arnold
Flag of United States of America image

something is not clear. do you mean you have master/master replication
or you mean that the procedure failed, and effectively each has their own database in read-write, no replication?
Avatar of Jasmin shahrzad
Jasmin shahrzad

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. 
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
yes i did. it working now i forgot the line standby_mode and chmod 600 on the recovery.conf file.
Thank you. Arnold