consistent postgresql snapshot - Mailing list pgsql-general

From Zwettler Markus (OIZ)
Subject consistent postgresql snapshot
Date
Msg-id 49bb084a06194e51a2d58421e5f074f6@zuerich.ch
Whole thread Raw
Responses Re: consistent postgresql snapshot
List pgsql-general

PostgreSQL12 running on CentOS7 + ext4.

 

Would it be save to do a "fsfreeze –freeze" + disk snapshot + "fsfreeze –unfreeze" of the PGDATA filesystem to get a consistent snapshot?

 

I am wondering as PostgreSQL default blocksize = 8k while ext4 default blocksize = 4k, resulting in 2 fs blocks per db block.

 

Thanks, Markus

 

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: PLPGSQL - extra column existence in trigger
Next
From: Bryn Llewellyn
Date:
Subject: Re: Deferred constraint trigger semantics