PostgreSQL DBA

Installation, Configuration & Memory

Question

initdb versus CREATE DATABASE: what does each initialize?

Answer

initdb creates a database cluster, including shared catalogs and template databases; use it once for a new data directory. CREATE DATABASE copies a template within an existing cluster; use it for an additional database.

This is 2 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples