How to convert Oracle to PostgreSQL Online

This article discusses tools for migrating schema online from Oracle to PostgreSQL and EDB Postgres Advanced Server. EDB Postgres Advanced Server and PostgreSQL Challenges of converting database schemas online Why...
January 19, 2023

How to tune PostgreSQL for memory

This article looks at parameters that can be used to help manage memory in PostgreSQL. Recommended settings for each parameter are also provided.
April 06, 2022

Managing Roles with Password Profiles: Part 3

Here in this blog, I’ll explain some new parameters for password profiles like PASSWORD_REUSE_TIME, PASSWORD_REUSE_MAX, and PASSWORD_ALLOW_HASHED (Added in v11). In the end, we will touch upon the DEFAULT profile...
April 16, 2019

Managing Roles with Password Profiles: Part 2

In Part 1, I have explained how FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME can be used to record user logins. In this post, I will explain how to manage a password including its...
April 09, 2019