Back to Developer Roadmap

Installation and Setup of PostgreSQL

src/data/roadmaps/postgresql-dba/content/installation-and-setup@FtPiBWMFhjakyXsmSL_CI.md

4.01.1 KB
Original Source

Installation and Setup of PostgreSQL

To install and set up PostgreSQL, begin by downloading the installer from the official PostgreSQL website for your operating system (Windows, macOS, or Linux). For Windows, run the installer and follow the prompts to configure components, set a password for the superuser (postgres), and choose the installation directory and port (default is 5432). On macOS, using Homebrew is the recommended method; simply run brew install postgresql in the terminal, then initialize the database with brew services start postgresql. For Linux, use the package manager (APT for Debian/Ubuntu or YUM for CentOS/RHEL) to install PostgreSQL, followed by initializing the database and starting the service. After installation, you can access PostgreSQL using the psql command-line tool to create databases and manage your data effectively.

Visit the following resources to learn more: