Follow the EnterpriseDB Blog for the latest on all things EDB Postgres. From news to how-tos, our community of PostgreSQL experts is always sharing leading-edge insights.
By Bruce Momjian
Tablespaces are designed to allow Postgres clusters to be spread across multiple storage devices. Create tablespace creates a symbolic link in the pg_tblspc directory in the cluster's data directory pointing to the newly-created tablespace directory. Unfortunately, though there is a command to move tables and indexes between tablespaces, there is...
MORE
By Prashant Agarwal
Since the launch in early August 2018, the EDB Postgres Migration Portal has been used to assess and migrate hundreds of Oracle database schemas, and convert them into EDB Postgres Advanced Server compatible databases. We have been improving the Migration Portal regularly since our launch with more functionalities, features, performance...
MORE
By Bruce Momjian
Usually, the database administrator controls who can access database data. However, it is possible for clients to completely control who can access data they add to the database, with the help of openssl. First, let's create rsa keys for three users from the command line. We first create an rsa public/private key pair for each user in their home...
MORE
By Daniel Williams
We most likely will be upending anyone’s world-view if we make the claim that database spend is a big slice of IT’s overall costs, and one that many businesses would love to shrink. Thirty to thirty-five percent is the figure you hear bandied about. Like any other denizens of the tech ecosphere, database vendors have seen their share of...
MORE
By Robert Haas
There have been a number of articles on the upcoming improvements in Postgres v11, including one by EnterpriseDB’s own Bruce Momjian.  A couple of the most commonly highlighted areas are in parallelism and partitioning.   Something I haven’t seen discussed much, however, is at the intersection of these two capabilities. In particular, Postgres...
MORE
Licensing complexity, rising costs, and audit risk are motivating Oracle customers to jump start their migration efforts to alternative database platforms, like open source-based Postgres. Gartner has recommended that chief data officers and CTOs, “add open-source RDBMSs...for new uses, and to replace commercial RDBMSs where these are not...
MORE
By Mithun Chicklore Yogendra
In PostgreSQL 11, a new functionality of autoprewarm has been added into the contrib module pg_prewarm.  This automatically warms the shared buffers with the same pages held before the last server restart. To accomplish this, Postgres now has a background worker to periodically record the contents of the shared buffers in the file -- “autoprewarm....
MORE
Database administrators need tools for database maintenance, performance optimization, configuration, and highly availability. EnterpriseDB (EDB) leads the industry in creating best-in-class Postgres tools to support DBAs with their mission critical enterprise deployments. One example is Postgres Enterprise Manager® (PEM). PEM is a comprehensive...
MORE
By Bruce Momjian
When storing data in the database, there is an assumption that you have to trust the database administrator to not modify data in the database. While this is generally true, it is possible to detect changes (but not removal) of database rows. To illustrate this, let's first create a table:   Continue reading on PostgresRocks to learn more. >...
MORE
By Dave Page
A couple of common questions I hear from customers (usually long-time users of a particular database from Redwood) via our guys in the field is “why do we install our software as root?” And “why do we run services as postgres?”. The simple, TLDR; answer is “for security”. A basic principle when securing a software installation is “install with...
MORE