Re: Feedback about hybrid SAN snap and rsync'd approach for large systemcloning

Hi Stephen, and thanks! Please see below... > Greetings, > * Jerry Sievers (gsiever...@comcast.net) wrote: > Suppose we have a DB cluster with an additional tablespace and we are > able to make an atomic SAN snapshot of *only* the main cluster > volume... > The additional tablespace contains on

Re: Feedback about hybrid SAN snap and rsync'd approach for large systemcloning

Greetings, * Jerry Sievers (gsiever...@comcast.net) wrote: > Suppose we have a DB cluster with an additional tablespace and we are > able to make an atomic SAN snapshot of *only* the main cluster > volume... > > The additional tablespace contains only UNLOGGED relations. > > We cannot snap that

Re: Feedback about hybrid SAN snap and rsync'd approach for large systemcloning

On Tue, 2022-04-12 at 18:07 -0500, Jerry Sievers wrote: > Suppose we have a DB cluster with an additional tablespace and we are > able to make an atomic SAN snapshot of *only* the main cluster > volume... > > The additional tablespace contains only UNLOGGED relations. > > We cannot snap that volu

Feedback about hybrid SAN snap and rsync'd approach for large systemcloning

Suppose we have a DB cluster with an additional tablespace and we are able to make an atomic SAN snapshot of *only* the main cluster volume... The additional tablespace contains only UNLOGGED relations. We cannot snap that volume so we use rsync as follows... 1. pg_start_backup('foo'); make SAN