Thu, 21 Mar 2024 14:15:02 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/enable-data-checksums-with-minimum-downtime-in-postgresql/ https://www.percona.com/blog/enable-data-checksums-with-minimum-downtime-in-postgresql/#respond Thu, 21 Mar 2024 14:15:02 +0000 https://www.percona.com/blog/?p=95182 PostgreSQL has a feature called data checksum which is used to detect any storage-level corruption of data pages. However, a new PostgreSQL database cluster does not have this feature enabled by default. To activate this feature, you must specify the –data-checksums flag when initializing a new PostgreSQL database cluster with the initdb utility.So what about […]]]> https://www.percona.com/blog/enable-data-checksums-with-minimum-downtime-in-postgresql/feed/ 0 95182 https://www.percona.com/blog/improved-createrole-attribute-for-user-management-in-postgresql-16/ https://www.percona.com/blog/improved-createrole-attribute-for-user-management-in-postgresql-16/#respond Fri, 15 Dec 2023 16:37:45 +0000 https://www.percona.com/blog/?p=92460 A database role can have a number of attributes that define its privileges and interact with the client authentication system.One such attribute is the CREATEROLE attribute, which is important to PostgreSQL database management of users and roles. In this blog post, we will discuss the improvement to this attribute that has been done for PostgreSQL […]]]> https://www.percona.com/blog/improved-createrole-attribute-for-user-management-in-postgresql-16/feed/ 0 92460 https://www.percona.com/blog/postgresql-job-scheduler-pg_timetable/ https://www.percona.com/blog/postgresql-job-scheduler-pg_timetable/#respond Tue, 03 Oct 2023 14:14:49 +0000 https://www.percona.com/blog/?p=90953 In database management, job scheduling has always played an important role. And for PostgreSQL, PgAgent and pg_cron are examples of job schedulers that are already popular. However, there is another job scheduler called pg_timetable, which is completely database-driven and provides a couple of advanced concepts. In this blog, we are going to highlight some of […]]]> https://www.percona.com/blog/postgresql-job-scheduler-pg_timetable/feed/ 0 90953 https://www.percona.com/blog/what-to-do-when-a-data-file-in-postgresql-goes-missing/ https://www.percona.com/blog/what-to-do-when-a-data-file-in-postgresql-goes-missing/#respond Mon, 26 Jun 2023 13:42:09 +0000 https://www.percona.com/blog/?p=88908 We have faced different levels of corruption related to databases in PostgreSQL. Our colleague has written multiple blogs on the subject; please refer to the below links for more: The Ultimate Guide to Database Corruption: Part 1 – An Overview The Ultimate Guide to Database Corruption: Part 2 – B-Tree Index Corruption In this blog, […]]]> https://www.percona.com/blog/what-to-do-when-a-data-file-in-postgresql-goes-missing/feed/ 0 88908