Postgres: The World's Most Advanced Open Source Relational Database
PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
There is a wealth of information to be found describing how to install and use PostgreSQL through the official documentation. The open source community provides many helpful places to become familiar with PostgreSQL, discover how it works.
We heavily recommend that if you spin up a container that requires a database you create a user for that container. You should NEVER use the root account for anything other than database management.
Make user a superuser¶
Create a database and owner to the new user¶
CREATE DATABASE newdatabase; ALTER DATABASE newdatabase OWNER TO newuser;
Created: October 30, 2023