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 1rjd1R-006msY-5x for pgsql-general@arkaria.postgresql.org; Mon, 11 Mar 2024 10:36:45 +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 1rjd1P-00BqlH-NY for pgsql-general@arkaria.postgresql.org; Mon, 11 Mar 2024 10:36:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjd1P-00Bql5-0u for pgsql-general@lists.postgresql.org; Mon, 11 Mar 2024 10:36:43 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjd1I-003utL-AF for pgsql-general@postgresql.org; Mon, 11 Mar 2024 10:36:42 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 84A815F7B7; Mon, 11 Mar 2024 06:36:30 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=snowman.net; s=dkim; t=1710153390; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=LaRE/la1Pb5enTJH9Pj/445rDRBFM/D1oCVoy+m3fsM=; b=Z0gORirBmAKVKRV2Z6/1Fpoihs9uw39WBBmx6j0i/cNzrOrwTQJX0dcXCqhcqw1/KXyXlz 4FFIkz5fkgyf4PTbOIpNI4BmFNYPeygmeKzKatBnAf13Iz0rmXvsAt4ZVHKciT9BeOj2y4 hJQy8ehwIylqJ3Wo6gLJB3XGMNA/H8s= Date: Mon, 11 Mar 2024 06:36:30 -0400 From: Stephen Frost To: Rama Krishnan Cc: Postgres General Subject: Re: About rsync Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="7LrSe9Fv74gGfe5D" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.1.4 (2021-12-11) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --7LrSe9Fv74gGfe5D Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Rama Krishnan (raghuldrag@gmail.com) wrote: > I have primary and stand by setup in that customer using wal_keep_segment > very low number and database size were also high so that cilent asking wi= th > me in order use pgbase backup can't we use rsyn >=20 > Here my question is if the wal is is presented on primary and not in > standby then rsync will work but if the wal files were missed at primary = if > I am using rsync to the db will be work here please explain me Not really following what's being asked here, but one thing that I can certainly say is that rsync, by itself, is not an acceptable solution for performing online backups of PostgreSQL. I'd strongly suggest you continue to use pg_basebackup or look into a more advanced tool like pgBackRest if you need a backup solution for PostgreSQL. Thanks, Stephen --7LrSe9Fv74gGfe5D Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIyBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmXu3qwACgkQ7WyKOINH ZFUF9Q/1HeDXIkdr7zs6r/Ialy9iT5GuY5FuhX5BKUv8VHYY2Lj5Zdcs+d1nicZJ hOYM8AjAMwFrGYMeB1umdj1qVuWX9Aka/sFCXLk7JvuFfrG5grJKyfbTnVxKsySW OiUKWzYzztkRIvnxf+WTeMOeztIiuxE0GJBFavcxS+IkUzUFuSz0MFr198Pd7Kc+ UBxlOfmMt2VnYb3ixXMt8dITkwxuhWATewCXCl0aHDbUvXT75+ehUtVQEF5MHFw4 S3TPmVbyiQa2ErGJSfkx71+2iStF8PL6wVP15TKVbQRYA6x91rimi7+rAncLHCLO /MHJT2ZIR8TLOgTVsnVmV+RsfEX7ujZkqnmK/yFHUa11JA9qsKBNeGuIDRbYUcq6 jAv8Kx4WtppoJ5Ea8ixQtDEPyWqd966aQD6n1F3HTeZfsNjkvqgzIf6F97ebMltf bJzidtgMNsMmPoKse+39j332xlFLm4VCBbSnd46KJ/1EknlWpl5E6gwZSbaFDbjG g+6BZ4CU0Mfw886gHi344w0BZkTNT4FYMzUV8ZKW8ywPNVZQGqqkwt0+ItmWKVTg WjZ18dGVEAvDTuAWoKJMnd4fhC7hMJIWFXqPP8fQTvsIIwmjgLy0cRwsl7zcqrDY 6cqCE1BHrhaIKjZI491XyMK7cR74uJtNnC++RlADeAKWnNu8BA== =OPs3 -----END PGP SIGNATURE----- --7LrSe9Fv74gGfe5D--