The Postgres data directory, sometimes known by the environment variable $PGDATA that references it is the heart of your database cluster installation. We as Database Administrators should never touch files within the data directory (with very few exceptions), as we could harm the integrity of the database software or completely destroy the database itself. That
Read MoreBy default, PostgreSQL server does not allow inbound connections over default port 5432. This means that only connections from the local machine can connect to the database. The following steps can be used to enable clients to connect over the network to PostgreSQL. Hope this helps,Dustin
Read MoreInstalling Oracle Database is a time-consuming process, especially when done manually. There are plenty of resources on the web for accomplishing the process using Vagrant, Ansible, or other automated build tools. These are helpful and tend to work well, but in some cases, we’re not allowed to make use of this tooling. Having to install
Read MoreManaging users and groups on GNU/Linux (referred to as Linux for brevity going forward) is done differently than on other operating systems, particularly those that make heavy (or nearly exclusive) use of graphical user interfaces. Linux was a command-line first operating system, and most of the administration associated with it is typically done via the
Read MoreAs anyone who has ever had the pleasure of installing Oracle Database has come to know, this process can be quite cumbersome and less than straightforward for someone new to working with Oracle technologies. I could even see how the wise ole’ gray beards may struggle with this if it’s been some time between installations.
Read MoreUse of a recovery catalog provides for additional protection against data loss. The catalog database holds information about databases, their structure, backupsets, and a host of other useful information. The best part about it is that all of this useful information for multiple databases is available in the tables and views of the user that
Read MoreFor most organizations using Oracle Database the de facto tool for monitoring instance health is Oracle Enterprise Manager Cloud Control. While Cloud Control is great at what it does, there are times when the Oracle Management Server (OMS), the Oracle Management Agent, or other components of Cloud Control are down. This could be during maintenance
Read More