Sat, 10 Feb 2024 01:18:48 +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/postgresql-upgrade-tricks-with-oid-columns-and-extensions/ https://www.percona.com/blog/postgresql-upgrade-tricks-with-oid-columns-and-extensions/#respond Mon, 03 Apr 2023 12:01:58 +0000 https://www.percona.com/blog/?p=86592 We are all aware that PostgreSQL 10 has reached end of support, and there is a need to upgrade to the latest version or any application-compatible PG version.Below are some of the upgrade options available to upgrade to PG11 or above.  Pg_dump and pg_restore:           We can refer to PostgreSQL Upgrade […]]]> https://www.percona.com/blog/postgresql-upgrade-tricks-with-oid-columns-and-extensions/feed/ 0 86592 https://www.percona.com/blog/generate-a-pgbadger-report-from-postgresql-flexible-server-logs/ https://www.percona.com/blog/generate-a-pgbadger-report-from-postgresql-flexible-server-logs/#comments Wed, 14 Dec 2022 14:40:59 +0000 https://www.percona.com/blog/?p=84001 In one of our previous posts Detailed Logging for Enterprise-Grade PostgreSQL, we discussed parameters to enable detailed logging and use Log Analyzer – pgBadger. In this blog post, we will configure a Microsoft Azure provisioned PostgreSQL Flexi Server to populate logs and generate a pgBadger report.The latest pgBadger Utility provides support for JSON format logs. […]]]> https://www.percona.com/blog/generate-a-pgbadger-report-from-postgresql-flexible-server-logs/feed/ 8 84001