Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uINoO-003Tzg-Lp for pgsql-admin@arkaria.postgresql.org; Fri, 23 May 2025 08:31:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uINoM-00GwP6-Ee for pgsql-admin@arkaria.postgresql.org; Fri, 23 May 2025 08:31:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uINoM-00GwOx-3x for pgsql-admin@lists.postgresql.org; Fri, 23 May 2025 08:31:25 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uINoJ-000Ttr-0b for pgsql-admin@lists.postgresql.org; Fri, 23 May 2025 08:31:25 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-70dec158cbcso33607157b3.2 for ; Fri, 23 May 2025 01:31:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747989082; x=1748593882; darn=lists.postgresql.org; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to; bh=fBs6WdplK/N8EW+OAICtdjhex0eEn3LhQRHHHkrbDt0=; b=WXkUyni4IKes4r0oNX/ywDLVx1CmMiHBR39gzHMA0/1iP/qPO6EVwSY33SzMur3Lj3 9J/cZcmWDrsRBwskDJdOp9x/+ve6K9s39mtDggIXmM6AvhPAyVPf1mZG54KxTAhmPZSz W7L17LY629cCBCEJD3Jfx6WDSmbQOw6mUMW5yG/fs9a/XTb42R3ICCihfpp7BqkwOrK0 gzhz4bMiZDFcjl/jUs9yNhZ96GWRRKwqsk36hYua1bA7+PaBY7mNaIf1MIB1NgPtjSXm GMafpKGlBMLHAy4Wc9xfUVeGQMEzv7RfpR4M3MX5EOwUU+Yn3F63JBndS3NQXMGAzAzE dqXA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747989082; x=1748593882; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=fBs6WdplK/N8EW+OAICtdjhex0eEn3LhQRHHHkrbDt0=; b=Ki5YDp5alsqyYR68CJNYAymZUkoejeI5DfEU8y0u6s3tcfPyWtVw5zCkVBlEzvTrQi 1PO92vXLNLe4is0xACnU0x6WP5UeXNHSRZ+DxvlJ5/PFT2y4JTnl2jdqVmiV0gwWkoBZ nVYb7AvQjmjiWLoU+xOI0mH+ArmKwywRw0ZlrtNd1kMV9gluYiuKeNZgMdurYeAKZ60j 9kSnsqSRHRUnwkOEmkiaFAZIeRVB4PG2ivg2ij3BPIhIrR9jKaVNqiM6A0eeSZrSGQTd 0KER1OIs2KW9YBl8wZDcgSJ+Qa3ksSvfv01CIX+zkujFadkZTt4534irJPw3CQpOtVGg Il/Q== X-Forwarded-Encrypted: i=1; AJvYcCXUHoK7+D9S7LVg3Wvuo+/H3n7558dFL3gB72GoBsNYxfyXXGvpPNG8FSwatmJaWOXPfTG3tSfVtusmBg==@lists.postgresql.org X-Gm-Message-State: AOJu0YzCP9Avt66FoT8wQS1fy5wLGEwt+8RoY45yBSjjRr4dYL6cBQir PhzyBVREv/p+dy3PrFTsmz6KkwQD8MaXcp/Ptap2NYF7mvyyAb7YxM57 X-Gm-Gg: ASbGncsInBm7GCDZfaQurAAjEO+iIHHh2qoINNA+Udbt0qT0fNf8/Hh0GxObk1E5aef uwSnqFZqRo2z6ZottM3dtSICXf1JpD+BSpSWfYFawrlkY9dl1takt0ltJ3IYpz9pUH77Cekni3O IeaTY4GiFtHXIr8+XiT1F7la7MlKZrhHCDlYtcGAfsV9l9Pphv5lYmqwxSKA+H4xR4VwGQvT6rM EWzB5Qxisif+5QbAS6xo+JCSyJytTMe2XrSsHfB8YD9YqNKa8QZJtEcQE63LBMdGnyTWEKGibC1 0gSv+G9ofF2FzZ3q1R99W5mdKcK8YCv12khAb3WxWo+5ByuXgM9GgpYW4Q/rAPoblOU= X-Google-Smtp-Source: AGHT+IG9Ls9W/IESMB4LWOCkW16SrzC1PCwHBk5e49L5BOBHPxGm/dUi0MSqmzwyfJ85RUjcSvyIog== X-Received: by 2002:a05:690c:ed4:b0:708:2604:4a10 with SMTP id 00721157ae682-70caafccab3mr386323447b3.18.1747989082200; Fri, 23 May 2025 01:31:22 -0700 (PDT) Received: from dcv-workpc.localnet ([2a02:2149:8af7:2100:cfe9:b5c1:ec40:f82]) by smtp.gmail.com with ESMTPSA id 00721157ae682-70e19dfedebsm2211557b3.52.2025.05.23.01.31.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 23 May 2025 01:31:21 -0700 (PDT) From: Dionysios-Charalampos Vythoulkas To: pgsql-admin , Pgsql-admin Cc: Wasim Devale Subject: Re: Replication lag Date: Fri, 23 May 2025 11:31:19 +0300 Message-ID: <6162737.lOV4Wx5bFT@dcv-workpc> In-Reply-To: References: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="nextPart5016410.31r3eYUQgx" Content-Transfer-Encoding: 7Bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --nextPart5016410.31r3eYUQgx Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" On streaming replication yes, you can perform read-only queries. On logical replication, as far as I know you can also run write queries, bu= t you have to be=20 careful to keep the data consistent. On =CE=A0=CE=B1=CF=81=CE=B1=CF=83=CE=BA=CE=B5=CF=85=CE=AE, 23 =CE=9C=CE=B1= =CE=90=CE=BF=CF=85 2025 10:13:10 =CE=A0.=CE=9C. EEST Wasim Devale wrote: > Hello, >=20 > Reply wal and query execution on replica can coexists? >=20 > Golden gate in oracle has this feature that they can coexists but in > postgresql do we have any provision like this. >=20 > Please assist. >=20 > Thanks, > Wasim --nextPart5016410.31r3eYUQgx Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="UTF-8"

On streaming replication yes, you can perform read-only queries.

On = logical replication, as far as I know you can also run write queries, but y= ou have to be careful to keep the data consistent.


On =CE=A0=CE=B1=CF=81=CE=B1=CF=83=CE=BA=CE=B5=CF=85=CE=AE, 23 =CE=9C=CE= =B1=CE=90=CE=BF=CF=85 2025 10:13:10 =CE=A0.=CE=9C. EEST Wasim Devale wrote:=

>= ; Hello,

>= ;

>= ; Reply wal and query execution on replica can coexists?

>= ;

>= ; Golden gate in oracle has this feature that they can coexists but in

>= ; postgresql do we have any provision like this.

>= ;

>= ; Please assist.

>= ;

>= ; Thanks,

>= ; Wasim



--nextPart5016410.31r3eYUQgx--