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 1tvERy-002cAC-6n for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 11:52:38 +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 1tvERw-00322B-UC for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 11:52:36 +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 1tvERw-00321z-IN for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 11:52:36 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvERu-0007Q2-0W for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 11:52:35 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-abec8b750ebso139152266b.0 for ; Thu, 20 Mar 2025 04:52:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742471552; x=1743076352; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=qqq1Qtai15TwpYH5W9T2Jd2tel3TbQCTVQniq/Pqdck=; b=FS77Gu7bP4fGjg12vnkiwS3LzzCWKZAt1m6TUsy1MbmLdn3csLxhTdGCy7O8aoVOmN szPpL615ZUK0Y5zolyNPvJAWKT2hqBM8V2v6li7SlkvzhWb0wxYqKZTt1g4qnlXEN1oR yemTHevZFwX93F8jORAr/9TQtWPqbuzorvbJNIsZrbeJUFBNk+9+ArqUpcjIOPbkZBiR 8PSsj9liu6LF9LtQHim9SwApdB5yO++pA5HK5rNTvPNLC7SfoMegJqR4/UYsggThjOxd zHTL3wI58usaQJTss8IFfJa6c6SGiNCR+fuMvIppVByOEZcuJrjLij6L4PvBbc2FH8T4 j9SA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742471552; x=1743076352; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=qqq1Qtai15TwpYH5W9T2Jd2tel3TbQCTVQniq/Pqdck=; b=wQMJeVA7TX11QrFVBLhll0HP3Q3zjqyvAZXj8Bex/hV3N06KO/gkVlFMV3+cqZi35l LLa0B4NwrtA3H9w/XSbFTUA52xIVs+9XoNwZhacdcwWIH6/VU9u2SD48mOy28RTfPQEw wu6gl6ahrt+OxFgupE/0BWi2vPQUKgDP93o3QEpbgufgonKBeq1DCHrqKyFxc3MUtO+9 OPdJ9VpRNyb9YyUQXcZnb6cifxixSz5kh6joaZiEp5ry1zSFAnasdoj0KmOxQ3lxfaXF IaG4I19KBDMfhq1pK1zDq/x6CrsdUNK7FeR9sYJYYcURmqGDLuM0uWTW9EdKkMakcf3x tO7Q== X-Gm-Message-State: AOJu0YwDg6npFsA8lZfIUq1xlrUGCOfg6PiG3uCFUPpc2eRh4noHnmqA 2DkN/02gNEeuS7Sliq3heavHvx2R3oNh/wrx23jXR6WDxgPiABvMS7oJX0qRzeXUgSLXtm01tjv o2V/jlg8lz+xM00RQGtK+J+6wkDfL9ROH6Z0= X-Gm-Gg: ASbGncsWjB/8NiLvs9Q/dt/N/8rV94sN8SNs5dzOasOOKMKRaDbdjjohYCXDfr0XzYF PN1HGyHqzSfffHpFxx/F3gRIfI26HH/AnvtH3RImZVvL5kt2kaylOVjDqm1Ajq7V3n50pU/T+0e fAoSunACmH2xUzb7W8A6OUBsnfy/4= X-Google-Smtp-Source: AGHT+IHaRwnpNWQ7j925ktUQTyFC68eTxRZkvN9ncBgVLUiGYLermv1jtp8GIEPPIYaKT7Qv8hel8JPiU9pF0FTAqb8= X-Received: by 2002:a17:907:84a:b0:abf:750b:93b8 with SMTP id a640c23a62f3a-ac3b7d8492bmr645319166b.22.1742471552028; Thu, 20 Mar 2025 04:52:32 -0700 (PDT) MIME-Version: 1.0 From: Siraj G Date: Thu, 20 Mar 2025 17:22:21 +0530 X-Gm-Features: AQ5f1JqNWShDSBGyoZY4Nh4miQgNgK5a_Cy-RGRni4XNDVqwCHS4Aayq-UUPHxg Message-ID: Subject: Export operation efficiency in read replica To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000e3d6cb0630c4c5e1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e3d6cb0630c4c5e1 Content-Type: text/plain; charset="UTF-8" Hello Experts! I have a DB with 1TB in size serving needs of one of our critical applications. I have a requirement to take export of the DB on a daily basis, but want to carry out this operation in read replica. The postgresql version is: 16.6 What would be the RPO of such backup? What would be the impact on the READ REPLICA with a long running export operation? Thank you! Siraj --000000000000e3d6cb0630c4c5e1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Experts!

I have a DB with 1TB= in size serving needs of one of our critical applications. I have a requir= ement to take export of the DB on a daily basis, but want to carry out this= operation in read replica. The postgresql version is:=C2=A016.6

What would be= the RPO of such backup?=C2=A0
What would be the impact on the READ REPLICA with a long running e= xport operation?

<= /span>
Thank you!
Siraj
--000000000000e3d6cb0630c4c5e1--