[PostgreSQL](https://www.postgresql.org/) is an open source relational database management system (RDBMS), often referred to as Postgres. ## Installation [Download](https://www.postgresql.org/download/) the installer for your operating system (for Windows, as of this writing, the official installer was hosted on enterprisedb.com). You'll be prompted to provide a password for the superuser. Write this down and don't lose it! After installing Postgres, you will be prompted to launch Stack Builder to download additional extensions. Install [[PostGIS]], a spatial extension, if you plan to include geospatial data in your databases. > [!example]- Installation Screens > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > >  > ## Getting Started You have a few options for interacting with a Postgres database. Explore the knowledge articles for each option described below. 1. GUI client: Use [[pgAdmin]], a database client for Postgres, installed with Postgres. 2. Command line tool: [[psql]] 3. Application: Use Python libraries such as [[psycopg2]] or [[SQLAlchemy]].