BE SHARING

Database management

Applying RU on Enterprise Manager 13c R5

16.12.2022 by Mouhamadou Diaw

We often apply Oracle Database RU. Like database Release Update can also be passed on Enterprise Manager. On this blog I am describing how we can update an OEM 13cR5 Update 10 to OEM 13cR5 Update 11. For this I(…)

Database Administration & Monitoring

PostgreSQL 16: Further reducing tasks that require superuser

14.12.2022 by Daniel Westermann

In a previous post we’ve seen that vacuum and analyze operations can be granted to users which are not superuser starting with PostgreSQL 16. Work is still in(…)

Database Administration & Monitoring

New cast testing functions for PostgreSQL 16

13.12.2022 by Daniel Westermann

As the development of PostgreSQL moves on, more and more new features get committed. A recently commit patch added two new functions, which can be used to validate if a cast will work and what error message would be returned(…)

Database Administration & Monitoring

Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check

09.12.2022 by Daniel Westermann

In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while developing(…)

Database Administration & Monitoring

Some tips when developing in PostgreSQL’s PL/pgSQL

06.12.2022 by Daniel Westermann

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures, nor(…)

Database management

2022.pgconf.eu Berlin conference for tech

31.10.2022 by Hervé Schweitzer

Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening we started(…)

Database Administration & Monitoring

Patching ODA HA from 19.14 to 19.16

26.10.2022 by Mouhamadou Diaw

Patching an ODA is always exciting. Preparing a patch of an ODA HA may seem more complicated that an single ODA. But it’s the same processus. All patching operations should be run on one node. In this document I am(…)

Cloud

Setup a PostgreSQL Instance in Google Cloud SQL

24.10.2022 by Julia Gugel

This blog will be the first of a series of blogs, to report about my experiences with Google Cloud SQL. In this blog we will setup a basic PostgreSQL instance in the Google Cloud. If you’re new to Google Cloud,(…)

Database Administration & Monitoring

Oracle Exchange Partition

21.10.2022 by Lazhar Felahi

The Oracle Exchange Partition is a method allowing to : exchange the data segments from a non partitioned table to a partitioned table exchange the data segments from a partitioned table to a non partitioned table. This method is useful(…)

Database Administration & Monitoring

Meson vs. make: PostgreSQL build and test times

19.10.2022 by Daniel Westermann

In the last post we’ve looked into how you can build PostgreSQL with Meson instead of the traditional way using configure/make. The reason for this was a thread(…)