۲ مطلب در خرداد ۱۴۰۳ ثبت شده است

initialize pgpool and syncs postgresql DBs

to sync 2 or more postgresql database that exist on seprate server (with specific IP) we have some way.

 

First we should tell about replication. replication uses when we want to make an backup from current exist postgresql DB. not a fix backup, an streaming replication that replicate each changes in primary DB on others backup DB.

So we can use this to make a mirror server, but what happen if we use write query (e.g. insert, update) on the secondery db (backup db)? ok we should not allow to write on db because every change on backup db cause to dismiss data because new data has been written on that when update from primary db. So what should we do? we should forward write query to primary db and after primary DB changes the replication send new data to backup DB so the user think write on the DB really worked while the write query forwarded to primary DB.

۰ نظر
علی فلاح

تجربه ی کامپایل CoreElec

به نام خدا.

سلام داستان از اونجا شروع شد که برای انجام یکی از تسک ها نیاز بود از دو دستور زیر استفاده کنم:

۰ نظر
علی فلاح