* Jerry Sievers (gsievers19@xxxxxxxxxxx) wrote: > Has anyone found a clever way to $subject that doesn't involved > calculating which are all of the files unnecessary to send and then > running rsync with an exclude list? > > I'm pondering this right now. Certainly an interesting issue to consider. I have to admit that I hadn't considered unlogged tables when working out how to do the hard-link-based approach. > ISTM for each unlogged table/index/toast in pg_class where > relpersistence='u'... > > rsync --exclude-from... (and exclude-from-file contains) > > */base/$dbid/$relfilenode > */base/$dbid/$relfilenode.* > */base/$dbid/$relfilenode_* > ... > > The leading * will match the old/new data directoryes being sent to the > standby. You would have to address tablespaces too, if you have any. > I have among others, a 5TB system w/about 40G of unlogged data. Honestly, sending an extra 40G out of 5TB (we're talking less than 1% here...) might be worth it to keep the process simple. Thanks! Stephen
Attachment:
signature.asc
Description: Digital signature
