Date: Thu, 22 Feb 2024 12:50:53 -0500
From: Stephen Frost <sfrost@snowman.net>
To: SathishKumar R <mail.to.sathishkumar.raja@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Backup and Recovery related
Message-ID: <ZdeJfXQ83krPouxf@tamriel.snowman.net>
References: 
 <CAKF5Uba08g3L3Ef-i4JAPS5p_ktcBtDH32uowhQtEYMjKmn06Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="DmrqO/rop/Ln+xKy"
Content-Disposition: inline
In-Reply-To: 
 <CAKF5Uba08g3L3Ef-i4JAPS5p_ktcBtDH32uowhQtEYMjKmn06Q@mail.gmail.com>
User-Agent: Mutt/2.1.4 (2021-12-11)
Archived-At: 
 <https://www.postgresql.org/message-id/ZdeJfXQ83krPouxf%40tamriel.snowman.net>
Precedence: bulk


--DmrqO/rop/Ln+xKy
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

* SathishKumar R (mail.to.sathishkumar.raja@gmail.com) wrote:
> Our organisation is now implementing a backup and recovery process.We use
> Debezium to collect change data, which requires wal_level=3Dlogical.
> Our backup method is as follows: every third day, full backup, and
> incremental backups for the remaining days.
>=20
> Is it feasible to take physical and incremental backups with
> wal_level=3Dlogical and archive_mode=3Don in postgres-15 ?

Yes, wal_level=3Dlogical is fine for doing online backups with PG.  I'd
suggest you look into a backup tool like pgBackRest for your physical
backups, which supports both full and incremental backups.

Thanks,

Stephen

--DmrqO/rop/Ln+xKy
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmXXiX0ACgkQ7WyKOINH
ZFUTkxAAgqgT5mq1RVPwsyixKj+NYloClsmRdniqu4ldmHUQaqqXysN1PN8KDvWx
eV+nMtmpkrDL6DyzUN7+9RkPdSH0zXMRzmkkzNfAjx6RdHRoPVaGM+jrk3p1+0Zq
TwffGQxgjZQO9Zzbtc8lf01FlWcEYTlLbx9EAD5WmmfrNbrDkX0tOui/yFqofjhe
R2IyMbwDDgRuJWBArW4FdKUdpNHAJq3+CaK3DwCU9DvZg43eX0ctk2/FZO7c+Yi0
ULOQyfagAAQFMnG0FlqpIjibC95eIzlnCliSA0S1r+RxjpAWtYrKIBpScaBz3rRh
m+phqenBqq7xudIm1BY9sYggvYmVHHCcRq+tGvZU0NFxxrdvmhYLhf27CToaAwTK
Vgx5fhqAlI44IySutmAGCws3HUf43q37IVC1aSR1ED+xLweTbqms8M3mVqDPKktx
bn4JNVu10oJaXCvpIo98o6ifuHEZRhgdFICwa1PG0QRQeISuf+0vCo2OSK60FY9e
5/0gCXAd6qB4JPSZuPhOoXUbTgdrWjQybYptbtSF6K+NVQcvs684CSTOp/8aGunf
5gB3c86aGJ3Q2JgPmTJ6CRqVoluUQEEp7yOgMUnCeG5HwwvlMNqo2v4fO69/kcnU
NJqNtgRESvA9h1mCC7WZOsTS+VxEBMB9tVleVs1/LYRJl4CuwUg=
=sst+
-----END PGP SIGNATURE-----

--DmrqO/rop/Ln+xKy--