replication standby-stream dan backup alirkan yapilmasi gereken
Definition Description
İkinci server dan backup almak isterken, backup islemi sorgusu uzun surerse, postgres sorguyu otomatik olarak kesiyor. Bunun onune gecmek icin asagidaki konfigurasyonu postgresql.conf dosyasi icinden degistiriyoruz.
#max_standby_archive_delay = 30s # max delay before canceling queries max_standby_archive_delay = 600s # max delay before canceling queries # when reading WAL from archive; # -1 allows indefinite delay #max_standby_streaming_delay = 30s # max delay before canceling queries max_standby_streaming_delay = 600s # max delay before canceling queries
